Thread: Date function
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
mfg mfg is offline
external usenet poster
 
Posts: 11
Default Date function

Thanks Ed problem solved.
--
mfg41


"ed" wrote:

On Aug 9, 3:46 pm, mfg41 wrote:
Thanks in advance for any help I can get.
I am trying to place a function in a cell that will let me know if the date
today is = or than the date in that cell. I keep getting #NAME coming up
when I try to do this. I have entered the date formula in the required cell.
M. Foster


put =today() in cell E5. Put the target date in F5 as (for instance)
8/10/07. Conditional format cell E5 to whatever you want if "cell
value" is "Greater than" =F5

ed