View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mfg mfg is offline
external usenet poster
 
Posts: 11
Default Date -Month/day/year

Thanks for all your help now on one of my worksheets I used this formula and
it works well however in D7 I ahve a date that is February 2008 and it
returns time is up.
=IF(D7=Today(),"Time is up","")

How do I make sure it reads the year as well?
Thanks again for all your help.
--
mfg41