Hi Dug,

Seems you're not using real Excel dates. You should, absolutely!
It looks like D2 is your month, C2 is the year and B2 is the day. Adjust if
I'm wrong.
In E2, put: =date(C2,D2,B2)

To add a year:
=Date(year(E2)+1,month(E2),day(E2))

etc

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Dug Rowland" <Dug wrote in message
...
Trying to add and subtract years and ormonths to dates and concidering
leap
years.
=IF(IF(D25,B2-365,IF(D2<3,B2-365,IF(C2/4=INT(C2/4),B2-363,B2-364)))<NOW(),NOW(),IF(C25,B2-365,IF(C2<3,B2-365,IF(C2/4=INT(C2/4),B2-363,B2-364))))
is too cryptic!