View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default if then date formulas

=IF(A11,TODAY(),"")

"IF A1 is greater than 1, THEN return today's date, ELSE do nothing."

Note you can change "do nothing" to whatever you need it to do.
--
Brevity is the soul of wit.


"Brad" wrote:

What I need is for todays date to show in a cell if a value equal to or
greater than one is placed in another cell. For instance, on an ordering
form if a one is placed in a qty ordered cell todays date would show up in
the last ordered cell. Hope that makes sense. I have been trying to figure
this one out on my own and I give up. Thanks to all in advance.