Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date value
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Date value
Resolved · Urgent Priority · Version 2003
Reply Wed 22 Apr 2009, 14:51Delegate 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
For upcoming training course dates see: Pricing & availability
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.
|