software

I figured out how to calculate the total based on the current date
=(DAY(TODAY())*2), however I want this to stop calculating at the end
of the month.--
Renz09
------------------------------------------------------------------------
Renz09's Profile: www.excelforum.com/member.php...oamp;userid=34069
View this thread: www.excelforum.com/showthread...hreadid=538353Hello
To get the last day of the month use this formula:
=DATE(YEAR(TODAY());MONTH(TODAY()) 1;0)
You can then use this in your formula to check for the day or the month

HTH
Cordially
Pascal

quot;Renz09quot; gt; a écrit dans
le message de news: ...
gt;
gt; I figured out how to calculate the total based on the current date
gt; =(DAY(TODAY())*2), however I want this to stop calculating at the end
gt; of the month.
gt;
gt;
gt; --
gt; Renz09
gt; ------------------------------------------------------------------------
gt; Renz09's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34069
gt; View this thread: www.excelforum.com/showthread...hreadid=538353
gt;