Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Month Calculation
I've got a spreadsheet and in cell A2 the user will input
a date. I'm trying to provide a calculation for cell B2 that will subtract 1 month from the date in cell A2. For instance, if the user types in December 12, 2003, then cell B2 would calculate to November 12, 2003. Of if they type in March 3, 2004, cell B2 would calculate to February 3, 2004. Of course the calculation would have to take into consideration that some months have 30 or 31 days and in the case of February 28 or 29 days. Any assistance someone could provide to me would be greatly appreciated. Thanks, Jamie .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Month Calculation
Jamie, try this in B2 =DATE(YEAR(A2),MONTH(A2)-1,DAY(A2))
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address to reply by email ** "Jamie" wrote in message ... I've got a spreadsheet and in cell A2 the user will input a date. I'm trying to provide a calculation for cell B2 that will subtract 1 month from the date in cell A2. For instance, if the user types in December 12, 2003, then cell B2 would calculate to November 12, 2003. Of if they type in March 3, 2004, cell B2 would calculate to February 3, 2004. Of course the calculation would have to take into consideration that some months have 30 or 31 days and in the case of February 28 or 29 days. Any assistance someone could provide to me would be greatly appreciated. Thanks, Jamie . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Month Calculation
so if it is Mar 31, what do you want the result to be? Would Mar 28 - 31
all resolve to Feb 28 for non leap years and Mar 29-31 all resolve to Feb 29 for leap years? Certainly such can be considered, but you haven't defined what the resolution is. -- Regards Tom Ogilvy "Jamie" wrote in message ... I've got a spreadsheet and in cell A2 the user will input a date. I'm trying to provide a calculation for cell B2 that will subtract 1 month from the date in cell A2. For instance, if the user types in December 12, 2003, then cell B2 would calculate to November 12, 2003. Of if they type in March 3, 2004, cell B2 would calculate to February 3, 2004. Of course the calculation would have to take into consideration that some months have 30 or 31 days and in the case of February 28 or 29 days. Any assistance someone could provide to me would be greatly appreciated. Thanks, Jamie . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Month Calculation | Excel Worksheet Functions | |||
Help!!! End of Month Calculation | Excel Worksheet Functions | |||
Month end calculation | Excel Worksheet Functions | |||
Month end calculation | Excel Discussion (Misc queries) | |||
month-to-month calculation | Excel Discussion (Misc queries) |