subtracting dates help

  • Thread starter Thread starter Clyde Lomax
  • Start date Start date
C

Clyde Lomax

Good evening all,

I need to subtract something like

Cell A1 Cell b1 c1
d1

1/29/2005 4/29/1971 = numberYears in c2l
number of months in d2


33
8

I can get the 33.70...but can't get the decimal to convert to a number in
another cell.


thanks to all,

Lomax
 
Hi,

Try the excel function datedif(start date, end date, interval)

Eg. A1 = 4/29/1971
B1 = 1/29/2005

In cell C2 type: =datedif(a1,b1,"y") <=====will give you 33 years

In cell D2 type: =datedif(a1,b1,"ym") <====will give you 9 months

A
 
You have to have the start date first. i.e.

the earlier date first or else you get num error

=DATEDIF(start_date,end_date,"y")


--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



Clyde Lomax said:
AJ,
I am getting #num! In both cells with the "datedif"
Click to expand...
 
How would I creat a function that would give count down timer for specific date, including the the hour seconds etc
I require it to count down from 2005/04/02 to todays current date and time
 
thanks. Works much better when I put the correct date in the cells.

the grey matter is not as resilient as it once was.

Thanks again and good night..

lomax
Peo Sjoblom said:
You have to have the start date first. i.e.

the earlier date first or else you get num error

=DATEDIF(start_date,end_date,"y")


--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
Click to expand...
 
Back
Top