Same stuff, another whey.............

=IF(TODAY()A1,IF(TODAY()<A2,A2,""),"")

Vaya con Dios,
Chuck, CABGx3


"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