Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date value

Date value

ResolvedVersion 2003

Wed 22 Apr 2009, 14:51 Delegate Amy said...

Amy has attended:
No courses

Date value

Hi there

I have a spreadsheet which logs the date a document was submitted to someone in one cell, and the date it was received back from them in another.

I would like to create another cell with a formula that would calculate the number of days between these two dates. Please could you advise me on how to do this?

Thanks

Wed 22 Apr 2009, 16:48 Trainer Anthony said...

RE: date value

Hi Amy. This is more complicated than you'd think, mainly because of the different number of days in each month. However, here's a link to a good primer in how to achieve this:

http://www.meadinkent.co.uk/xl_birthday.htm

Hope this helps,

Anthony

Wed 29 Apr 2009: Automatically marked as resolved.

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips

Date value

Date value

RE: date value

Excel articles

Excel tip:

Screen Splitters in Excel