| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What formula do I use to add to a date column in Excel?
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! |
|
#2
|
|||
|
|||
|
The date would be 31/12/2004, not 2005.
=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1)-1) HTH Jason Atlanta, GA -----Original Message----- 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! . |
|
#3
|
|||
|
|||
|
Works perfectly, thank you very much!
Donna "Jason Morin" wrote: The date would be 31/12/2004, not 2005. =DATE(YEAR(A1)+5,MONTH(A1),DAY(A1)-1) HTH Jason Atlanta, GA -----Original Message----- 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! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Format an excel column as a date for a 5 day week for a year. | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
| In Excel, I need a date math formula... | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
