Re: I need to figure out how to get this =(DAY(TODAY())*2) to stop calcul. at end of mnth

Giganews Newsgroups
Subject: Re: I need to figure out how to get this =(DAY(TODAY())*2) to stop calcul. at end of mnth
Posted by:  papou (cestpasb…@├žanonplus)
Date: Wed, 3 May 2006

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" <Renz09.2783ka_1146645300.9281@excelforum-nospam.com> a écrit dans
le message de news: Renz09.2783ka_1146645300.9281@excelforum-nospam.com...
>
> 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?action=getinfo&userid=34069
> View this thread:http://www.excelforum.com/showthread.php?threadid=538353

Replies

None

In response to

I need to figure out how to get this =(DAY(TODAY())*2) to stop calcul. at end of mnth posted by Renz09 on Wed, 3 May 2006