Thread
:
I need to figure out how to get this =(DAY(TODAY())*2) to stop calcul. at end of mnth
View Single Post
#
2
Posted to microsoft.public.excel.misc
papou
Posts: n/a
I need to figure out how to get this =(DAY(TODAY())*2) to stop calcul. at end of mnth
Hello
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
"Renz09" a écrit dans
le message de news:
...
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:
http://www.excelforum.com/member.php...o&userid=34069
View this thread:
http://www.excelforum.com/showthread...hreadid=538353
Reply With Quote