conditional format on dates

2 posts / 0 new
Last post
conditional format on dates


I have a question regarding conditional formatting.

I have set up a spreadsheet that has product certificates and these have an expiry date.

I want to have the date cell highlight red if the current date is within 3 months of the expiry date.

I was wondering if someone could help me with this.

Kind Regards,

How to avoid "Negative" Date Calculations

When trying to figure out the number of days between two dates, but avoid a negative number if the start date is after the reporting date, I used the following formula:


However, if the start date is 1/1/2017 and the report date is 12/31/2016, the result is "42,735" instead of "0".

Is there an easy solution to this problem?

Add new comment