Previous month date format constant

  • Thread starter Thread starter Marilyn
  • Start date Start date
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
 
=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
Date format textbox? 2
Convert Date string to date format 7
Custome Format 2
Identifing Weeks in a Month. 3
Extract month from date 2

Back
Top