View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
mr_teacher mr_teacher is offline
external usenet poster
 
Posts: 1
Default Today() Now() and other stories!!!!


Not sure if this is exactly hat you want but seems to work as a work
around on mine!!!

=IF(((TODAY()-E1)/6574.5)1,"No","Yes")

The 6574.5 being 18 multiplied by 365 1/4 days to get the correct
number f days?

Any better?

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=564779