Datediff in Excel

[Cheveliar]

I used the help funtion but this returns me a date not a number.

DATEDIF(start_date,end_date,unit)

I want to get a number not a date

 

[carrr]

If A1 is start date and B1 is end date, then in C1, format the column to number format and use =A1-B1.

"'Tis an ill wind that blows no minds." - Malaclypse the Younger

 

[Cheveliar]

Nope that is not it...I am trying to calculate the months between both start and end date and then multiply by 12 to get an age...

 

[KenWright]

Help on Datedif is pretty much useless. Take a look at Chip Pearson's site for a much fuller explanation:-

http://cpearson.com/excel/datedif.htm

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[Cheveliar]

Thanks boss I am all over it...