| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate the first monday of a month in the future or in the past
Hello.
If I have a date in cell a1, what would be the formula to calculate the first Monday of the next month (+1 month), and then the first Monday of next month after that (+2 months)? Also, would this formula be able to be used to calculate first Monday of the current and the past months? (I assume you can just change a number in the formula). -- Thanks, Morocco Mole |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fiscal year calsulations for past to future dates. | Excel Discussion (Misc queries) | |||
| Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
| Date calculation for Monday of one month to the Monday of the next | Excel Discussion (Misc queries) | |||
| How do I Calculate a future or past date in Excel? | Excel Discussion (Misc queries) | |||
| Highlight past & future events | Excel Discussion (Misc queries) | |||
Threaded Mode
