Hi,
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,
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:
=IF(D24>$C$3,0,(+$C$3-D24))
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