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.
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.
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" <[email protected]> a écrit dans
le message de news: [email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks