ExcelBanter - Previous month date format constant

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Previous month date format constant (https://www.excelbanter.com/excel-discussion-misc-queries/198628-previous-month-date-format-constant.html)

Marilyn

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

Dave Peterson

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

All times are GMT +1. The time now is 05:58 AM.