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 |
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 |
All times are GMT +1. The time now is 10:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com