| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Month Format summation
Hi. I have this excel spreadsheet as the followings :
Column A1 = 3 (in number) Column B1 = 1/4/2006 C1 = 1/1/2006 (answer) I need to find out what is the previous 3 months before 1/4/2006 in C1. Do I have to format Column A1 (3) in the month format as it is just a number. Thank you in Advance !! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Month Format summation
in C1, write
=B1-A1 it should work. "Shirley" wrote in message ... Hi. I have this excel spreadsheet as the followings : Column A1 = 3 (in number) Column B1 = 1/4/2006 C1 = 1/1/2006 (answer) I need to find out what is the previous 3 months before 1/4/2006 in C1. Do I have to format Column A1 (3) in the month format as it is just a number. Thank you in Advance !! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format (month and year) = Today() | Excel Worksheet Functions | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| HELP with this function | Excel Worksheet Functions | |||
| How to format a date to a different format | Excel Discussion (Misc queries) | |||
| How do I format the date in a footer to display the month in lett. | Excel Discussion (Misc queries) | |||
Linear Mode
