• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Helper column to check if date falls within last 18 months

S

Swati Vishwanathan

New Member
Hello

We want to build a chart that contains data for last 18 months only. We dont want to use timeslicer

I though of using a helper column. I don't want to use a rolling count of days in my formula

I want to build a helper column to check if the date was within the last 18 months

So if we have a date 6/4/2014- it is not in the last 18 months.

I want to be able to obtain the first day of the month and go back 18 months from there.

Regards
Swati
 
If your dates are in column A, then in Column B =IF(A2>EOMONTH(TODAY(),-1)-545, "Less","Greater") and copy down.
 
=A2>(EOMONTH(TODAY(),-19)+1)

This will return True if the value is within the last 18 months, False if it isn't
 
You must log in or register to reply here.
Back
Top