What formula do I use to add to a date column in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help! We have a date in the format 01/01/2000 in column A1. We need to
produce a date in column B1 that is five years on minus one day (i.e.
31/12/2005). Does anyone know of a way to do this?

Many thanks!
 
The date would be 31/12/2004, not 2005.

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

HTH
Jason
Atlanta, GA
 
Works perfectly, thank you very much!

Donna

Jason Morin said:
The date would be 31/12/2004, not 2005.

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

HTH
Jason
Atlanta, GA
Click to expand...
 
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

LOOKUP function between two dates in Excel 2007 6
Help to create a macro 2
excel "IF" formula... if this possible ??? 0
Specific Date from a Range 3
Excel Formula Help! 2
LOOKUP within a 1
Date Formula Excluding Weekends 3
group of dates 1

Back
Top