Conditional Formatting

[Steved]

Hello from Steved

Our company used to do reports on every 28 Days

Below is the formula I used, however now the company whats to report at the
end off each calendar month, Question how do I modify below to acheive this
please, or is their another formula that will do the same (Conditional
Formatting).

=MOD(A1-DATE(2006,2,4),28)=0

Thankyou.

 

[Steved]

Hello from Steved

Below is the formula I received from Ron which works perfectly.

Thankyou.

=MONTH(A1)<>MONTH(A1+1)

 

[daddylonglegs]

Do you just want the last day of each Calendar month, in which case

=DAY(A1+1)=1

or do you want the last working day of each month?

 

[Steved]

Hello daddylonglegs

The last day of each month

Thankyou.