Formula for Date Comparison
Closed
Erin
-
Nov 10, 2015 at 10:14 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 10, 2015 at 11:19 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 10, 2015 at 11:19 AM
Hello,
I am looking for a formula that will compare two columns with dates. It would be column F and Column I. I would like Column I to change colors when it is 3 days after column F. Would anyone be able to help me out on this one?
Thank You.
Erin
I am looking for a formula that will compare two columns with dates. It would be column F and Column I. I would like Column I to change colors when it is 3 days after column F. Would anyone be able to help me out on this one?
Thank You.
Erin
Related:
- Formula for Date Comparison
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 10, 2015 at 11:19 AM
Nov 10, 2015 at 11:19 AM
for date simple subtraction would work
like
=I2>f2+3
like
=I2>f2+3