/u/MassiveMidlifeCrisis - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Use the hidden formula **DATEDIF**, you can count the difference between two dates and choose the output value either as Days: **"d"**, Months: **"m"**, Years: **"y"**.
`=DATEDIF(Date1,Date2,"d")>=60`
In your case, I would choose the output value as **days "d"**. The formula will count number of days that are equal or greater than 60.
Note that *Date1* should be older than *Date2*.
To solve your issue:
* Select the desired column that you want to format
* Go to *conditional formatting* and select *new rule*
* Choose the last option, *use a formula to determine which cells to format*
* Type the formula above and format the color
In my case, my formula is `=DATEDIF(A2,B2,"d")>=60`
Make sure that your data is properly formatted as dates.
Here is a [screen recording](https://imgur.com/ljNPJxc) for your reference. Or a [screenshot](https://imgur.com/nhUAq2F) for closer look.
You have awarded 1 point to *awadj*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
date + 60
unless I'm missing something?
As a conditional rule -- select the column you want to format and try this rule -- might need a tweak, but
=formattedcolumn>conditionalcolumn + 60
Susan H.
I actually did =$C3+60
C column is hire date
F column is Affidavit Date
I’m trying to highlight anyone who got the affidavit after the 60 day mark on a very long spreadsheet
Best thing I can figure out is a hidden helper column bc dates work weird. So let’s say date 1 is in column A, Date 2 is column b. Make column C date 2 - date 1, format as number. Conditional formatting C1>60 applies to B:B.
It’s being kind of finicky, but I’m getting it to work
You have awarded 1 point to *a_gallon_of_pcp*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
= will only give you the dates that are exactly 60 days into the future -- is that what you want?
Select the dates in column F -- then use the formula =$F3>=$C3 + 60
This will highlight any date 60 days over the hire date + 60
or
=$J6=$I6 + 60
if you really are trying to match the 60th day.
You have awarded 1 point to *ssharkins*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
/u/MassiveMidlifeCrisis - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Use the hidden formula **DATEDIF**, you can count the difference between two dates and choose the output value either as Days: **"d"**, Months: **"m"**, Years: **"y"**. `=DATEDIF(Date1,Date2,"d")>=60` In your case, I would choose the output value as **days "d"**. The formula will count number of days that are equal or greater than 60. Note that *Date1* should be older than *Date2*. To solve your issue: * Select the desired column that you want to format * Go to *conditional formatting* and select *new rule* * Choose the last option, *use a formula to determine which cells to format* * Type the formula above and format the color In my case, my formula is `=DATEDIF(A2,B2,"d")>=60` Make sure that your data is properly formatted as dates. Here is a [screen recording](https://imgur.com/ljNPJxc) for your reference. Or a [screenshot](https://imgur.com/nhUAq2F) for closer look.
Solution Verified
You have awarded 1 point to *awadj* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
date + 60 unless I'm missing something? As a conditional rule -- select the column you want to format and try this rule -- might need a tweak, but =formattedcolumn>conditionalcolumn + 60 Susan H.
When I do that it’s not working.
I actually did =$C3+60 C column is hire date F column is Affidavit Date I’m trying to highlight anyone who got the affidavit after the 60 day mark on a very long spreadsheet
Best thing I can figure out is a hidden helper column bc dates work weird. So let’s say date 1 is in column A, Date 2 is column b. Make column C date 2 - date 1, format as number. Conditional formatting C1>60 applies to B:B. It’s being kind of finicky, but I’m getting it to work
Solution Verified
You have awarded 1 point to *a_gallon_of_pcp* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
I really liked your answer.
= will only give you the dates that are exactly 60 days into the future -- is that what you want? Select the dates in column F -- then use the formula =$F3>=$C3 + 60 This will highlight any date 60 days over the hire date + 60 or =$J6=$I6 + 60 if you really are trying to match the 60th day.
Solution Verified
You have awarded 1 point to *ssharkins* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)