Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to design a spreadsheet where I only need to enter the "month" and
"year" as the starting point, then the formula will yield the "last date" of the months (starting from the month entered). For example, if I entered "11" for month and "2007" for year, then I want excel to yield "11/30/2007", "12/31/2007", "1/31/2008", etc. How do I write this formula? Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If date is in the month of Sept, then "1", otherwise "2" | Excel Worksheet Functions | |||
Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
write a "if" command. day of month + remainder | Excel Worksheet Functions | |||
Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
conditional formula to show "open" or "closed" | Excel Worksheet Functions |