Math with Dates?

  • Thread starter Thread starter kelemvor
  • Start date Start date
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
 
=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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Display certain dates 9
Excel 2000 and date math 3
Conditional Formatting with dates 3
Expanding Date formula 1
Conditional format for date 4
The death of music TV channels in UK - but not Europe? 4
Change Default Auto-Fill-In month 4
Which is the best MBOX Converter Tool different formats conversion? 4

Back
Top