Birtdates

[spill93]

Trying to figure out a formula between a birthdate and the day before the 70th birthday. leap years come into play so it doesn't seem to work for the 366 days following 2/29/__

[olasa]

Not quite sure what the problem is, but perhaps this will help:

=Date2-Date1 --> formated as General will show the number of days between the two dates.
=WEEKDAY(Date2, 2) will return the weekday starting with Monday as 1.

Ola Sandström

[cycling-rod]

Have a look here: http://www.exceltip.com/st/Calculati..._Dates/86.html Try not to count the days: 70 will come soon enough!