98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date value
Date value
Resolved · Urgent Priority · Version 2003
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
Wed 22 Apr 2009, 16:48Trainer 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 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. |
Excel tip:Calculate age or serviceThe DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip: |
