the date A1 will be exactly 180 days old
Col A........Col B
176..........3/29/10

What is 176?

--
Biff
Microsoft Excel MVP


"Donna" wrote in message
...
First let me say how much you all have helped me in my job to make our
processes more efficient. You make me look like a star at work, but only
Microsoft knows for sure! Anyway you guys are AWSOME!

My question:

Col A Col B

176 3/29/10

172

I want to know in Col B the date A1 will be exactly 180 days old, but
only
if it is 180 days in the current month. In column B1 I would expect to see
3/29/10.
In Col B2 I would not expect to see any date as A2 would not age out to
180 until next month.
Thanks for your help