Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 and date math
I am trying to allow a user to enter a date and then calculate the month
before. Eg. Enter in Cell A1 3/31/2009 Cell A2 will calculate automatically 2/28/2009 If Cell A1 is 1/1/2009 then A2 should automatically calculate 12/1/2008 so that years and leap years are accounted for. Ultimately I want to be able to calculate the same month in the previous year but I think I can do this with Month(A1)&"/"&Day(A1)&"/"&Year(A1)-1. I was trying to find a DateAdd function but can't so I am not sure how to approach this directly in Excel or should I get into VBA (never really done this before). Any help is appreciated TIA rasinc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What date is7 days from given date in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 - Highlighting a date. | Excel Discussion (Misc queries) | |||
Date Math | Excel Discussion (Misc queries) | |||
Date Math Problem | Excel Worksheet Functions | |||
In Excel, I need a date math formula... | Excel Discussion (Misc queries) |