if then date formulas
You should then fix that value, otherwise if you open the file on
another day then it will show that day's date, rather than the date
when the order was placed.
Hope this helps.
Pete
Dave F wrote:
=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.
|