Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with date formulas in Excel
I need to subtract 3 years from dates in a spreadsheet, i.e. 11/1/2005 minus
3 years. All of the help formulas show that you have to enter the month, day, and year numbers into the formula for each date. I would like to use a formula that allows me to use the date values in the cell references, something like A1- three years. Thank you! |
#2
|
|||
|
|||
Help with date formulas in Excel
=DATE(YEAR(A1)-3,MONTH(A1),DAY(A1))
-- HTH RP (remove nothere from the email address if mailing direct) "LLEW" wrote in message ... I need to subtract 3 years from dates in a spreadsheet, i.e. 11/1/2005 minus 3 years. All of the help formulas show that you have to enter the month, day, and year numbers into the formula for each date. I would like to use a formula that allows me to use the date values in the cell references, something like A1- three years. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel ignores boot-time regional settings when interpreting a date | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Excel date formulas | Excel Discussion (Misc queries) |