Datedif

Resolved · Low Priority · Version 2003

Tue 10 Mar 2009, 15:35 Delegate 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:21 Trainer 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.xls

Thu 19 Mar 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally 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.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips