I have todays date on my spreadsheet, need help with doing an expiration date column that will change to red 20 days before expiration. Cant figure out the formula, please help? Thanks.
MacBook Pro with Retina display, OS X El Capitan (10.11.1)
Hi Emtsrus,
Conditional Highlighting in Column A. Select the cell(s) then click on Conditional Highlighting
Add a Rule > Dates > In the Next
As another reminder, formula in B2 (and Fill Down)
=DATEDIF(TODAY(),A2,"D")
Regards,
Ian.
Hi Emtsrus,
Conditional Highlighting in Column A. Select the cell(s) then click on Conditional Highlighting
Add a Rule > Dates > In the Next
As another reminder, formula in B2 (and Fill Down)
=DATEDIF(TODAY(),A2,"D")
Regards,
Ian.
Thanks for the info, I will give it a shot. Your help is greatly appreciated.
Need help with a expiration date
