Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Renz09
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
papou
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to stop a general format cell Gaufres Excel Worksheet Functions 1 April 21st 06 06:57 AM
Splitting a Target Figure oldgit99 Excel Worksheet Functions 3 August 23rd 05 02:50 PM
How do I stop excel automatically changing my date to 2005? zoemcb Excel Discussion (Misc queries) 6 April 30th 05 02:39 AM
how to type a minues figure jenniss New Users to Excel 1 February 8th 05 04:05 PM
How do I stop other circles in other boxes to stop selecting? stauff Excel Worksheet Functions 1 October 28th 04 10:27 PM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"