If Today < Yesterday, but than Tomorrow
=IF(AND(TODAY()A1,TODAY()<A2),A2,"")
--
David Biddulph
"Trackeous" wrote in message
...
Sorry about replying to your email to ask a question, but the system won't
allow me to post a question - it just acts like I didn't press any
buttons.
What I am looking for is:
1. have Excel look at the Date in Cell A1,
2. have Excel look at the Date in Cell A2,
3. if today() A1 and today() < A2 then display A2.
I've experimented with various functions and either get "True" or
something
else.
Can you help?
Thanks
|