Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to figure out how to get this =(DAY(TODAY())*2) to stop calcul. at end of mnth
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop a general format cell | Excel Worksheet Functions | |||
Splitting a Target Figure | Excel Worksheet Functions | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
how to type a minues figure | New Users to Excel | |||
How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions |