On Jun 25, 11:17 pm, "Rick Rothstein \(MVP - VB\)"
wrote:
Here's one possible way:

A1: =DATE(YEAR(TODAY()),MONTH(TODAY()),1)
A2: =IF(MONTH($A$1+ROWS($1:1))=MONTH($A$1),$A$1+ROWS($ 1:1),"")

Fill down to A31

--ron- Hide quoted text -

- Show quoted text -

Thanks for the response Ron.

The first and second rows worked and gave me Jun 1st and Jun 2nd. But
the rest (3 - 31) also come up as June 2nd.

Check what you did again... it worked fine for me.

Rick

The answer is that my workbook was not doing calculations, but
manually.

Ron, I am in awe. Thanks again!

BTW, that second formula is definitely ugly.