Previous month date format constant

M

Marilyn

Hello I formated a cell , MMMM-YYYY. I would like this cell to always
have the previous month. in Excel 2002. THanks in advance
 
D

Dave Peterson

=TODAY()-DAY(TODAY())
will be the last day of the previous month.

You can format the cell any way you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Date Format 5
Excel and Busines Objects . . 2
Month function 3
Convert Date string to date format 7
Date format textbox? 2
Extract month from date 2
Custome Format 2
3-Color Scale Vlookup for Current Month/Previous/Pre-Previous 2

Top