Math with Dates?

K

kelemvor

I'm sure this is easy but I have some dates that were entered in Exce
and it automatically filled in the current year but the dates wer
actually from last year. How can I make a command to basically tak
the date and remove 1 year from it?

Possibly a second column that can do a function to do that to get th
new dates and then I can copy it over the old ones or whatever would b
easiest.

Thanks
 
P

Peo Sjoblom

=DATE(YEAR(A1)-1,MONTH(A1),DAY(A1))

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
Top