• 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.

Expiring cells after one year - formatting

L

lm38sp

New Member
I have been fighting Conditional Formatting and making New Rules yet nothing I do is working. I am building a spreadsheet that I enter dates that employees have called off work. I need these dates to either erase (or look erased) or turn a separate color after 365 days have passed from the date entered.
Please help!!
 
Hi,

Bit confused, suppose date entered is 1-Jan-2013, now if today's date is greater than 365 days from this date you want CF to work? If so try below formula IN CF.

=TODAY()>=(B5+365)

Considering date is in B5.

Regards,
 
Thanks! That seems to be working.
What if I want it to be a date other than today that I want referenced?
 
@Khalid NGO

The formula check if today date is greater than or equal to the ref. date by 365 days.

So 1/1/2014 + 365 will be greater than today, so FALSE, but today is greater than 1/1/2013+365 , so TRUE.

Regards,
 
Thanks Sir Somendra,
Actually I realized that after few. (therefore i did edit my post)
Pardon me for unnecessary question.
 
You must log in or register to reply here.
Back
Top