Ageing dates

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

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
 
Back
Top