Ageing dates

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
 
D

David Biddulph

176 was presumably the number of days old when Donna wrote her message (25th
in her part of the world).

Try
=IF(TEXT(TODAY()+180-A1,"mmmyyyy")=TEXT(TODAY(),"mmmyyyy"),TODAY()+180-A1,"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I combine 2 data sets using date? 2
SUM Q 2
Average top third with criteria 2
Month (MMM) from date (dd/mmm/yy) 1
Conditional Formatting - Cannot get it to work, please help 1
Copy Cell in other sheet 1
Adding the last 8 days of data 5
Create dates for year, allow for leap year 8

Top