software

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.

Hello from Steved

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

Thankyou.

=MONTH(A1)lt;gt;MONTH(A1 1)

quot;Stevedquot; wrote:

gt; Hello from Steved
gt;
gt; Our company used to do reports on every 28 Days
gt;
gt; Below is the formula I used, however now the company whats to report at the
gt; end off each calendar month, Question how do I modify below to acheive this
gt; please, or is their another formula that will do the same (Conditional
gt; Formatting).
gt;
gt; =MOD(A1-DATE(2006,2,4),28)=0
gt;
gt; Thankyou.


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?--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=501875Hello daddylonglegs

The last day of each month

Thankyou.

quot;daddylonglegsquot; wrote:

gt;
gt; Do you just want the last day of each Calendar month, in which case
gt;
gt; =DAY(A1 1)=1
gt;
gt; or do you want the last working day of each month?
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=501875
gt;
gt;