| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Previous month date format constant
Hello I formated a cell , MMMM-YYYY. I would like this cell to always
have the previous month. in Excel 2002. THanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Previous month date format constant
=TODAY()-DAY(TODAY())
will be the last day of the previous month. You can format the cell any way you want. Marilyn wrote: Hello I formated a cell , MMMM-YYYY. I would like this cell to always have the previous month. in Excel 2002. THanks in advance -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Overriding zero-strings with previous line constant | Excel Discussion (Misc queries) | |||
| THe Last DATE of the previous month from today | Excel Worksheet Functions | |||
| THe Last DATE of the previous month from today | Excel Worksheet Functions | |||
| Date of the First day of the previous month | Excel Discussion (Misc queries) | |||
| date of last friday of previous month | Excel Discussion (Misc queries) | |||
Linear Mode
