Date Formula for days of the month, new dates starting on the 2nd of the month.

I have a workbook that imports reporting data from the previous day, and puts it into the cell for the currrent day -1. The first cell automatically references the first day of the current month. The date changes to the new month on the first, but my report needs to hold on to the previous month until after it runs on the 1st.

What formula can I use that will make the first cell equal to the first day of the current month AFTER the first of the month?

In English it would read "If day > 1 then DATE(YEAR(TODAY()),MONTH(TODAY()),1)" or "If day >= 2" whichever makes the most sense.
The rest of the cells are equal to the previos cell + 1, so I only need the formula for the top cell.

Sorry, I posted my reply in the wrong place. I'll try again.

Originally Posted by CANAPONE

Hi,

an attempt

=DATE(YEAR(TODAY()),MONTH(TODAY())-(DAY(TODAY()=1),1)

Regards

This generated an error in the formula. I don't see what the error is. Any thoughts?