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

1. ## 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.

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

Hi,

an attempt

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

Regards

3. ## Re: Date Formula for days of the month, new dates starting on the 2nd of the month.

Try

=EOMONTH(A1,IF(DAY(A1)=1,-2,-1))+1
or
=EOMONTH(A1,-1-(DAY(A1)=1))+1

4. ## Re: Date Formula for days of the month, new dates starting on the 2nd of the month.

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

5. ## Re: Date Formula for days of the month, new dates starting on the 2nd of the month.

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?

6. ## Re: Date Formula for days of the month, new dates starting on the 2nd of the month.

Hi again

sorry: lost a parenthesis from Italian traduction

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

Regards

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1