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 » Datedif
Datedif
Resolved · Low Priority · Version 2003
Tue 10 Mar 2009, 15:35Delegate Faye said...
Faye has attended:
Excel Intermediate course
Datedif
How can you use datedif to give the answer in years and months?
Fri 13 Mar 2009, 09:21Trainer Cress said...
RE: Datedif
Hello Fave
Thank you for your question
The Datedif formula is not designed to give years and months together, it is only designed to give them seperately, please find example in the attached spreadsheet.
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
Attached files...
DATEDIF.xlsThu 19 Mar 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:Convert a column into row quickly in Excel 2010Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa. |
