Thread: Previous month date format constant
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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 With QuoteReply With Quote