Months and Week Days

[JakeMann]

Hi All,

Need a bit of help with a formula for the attached.

If I have a week that begins with the end of the month then I want a formula to show the following month.

Or if 75% of a week is showing July for example, and the remaining 25% is showing June, then I need something that says July or a month number...

Not sure where to start, can anyone help?

[daffodil11]

=IF(MONTH(A2+1)=MONTH(A2),A2,A2+1)

(FORMATTED FOR "mmm")


Are you trying to build a calendar?

[JakeMann]

I'm just doing some tests for a colleague, but that formula seems to have done the trick, thank you.

[daffodil11]

Alternatively, this will test for both conditions; end of month and first day of week

=IF(AND(A2=EOMONTH(A2,0),WEEKDAY(A2,2)=1),A2+1,A2)