gymwrecker
Active Member
- Joined
- Apr 24, 2002
- Messages
- 396
- Office Version
- 365
- Platform
- Windows
- MacOS
Need help with a conditional formatting formula that will change the text in B2 to "red" when the date is past the six-month mark.
For example, 15 Mar 23 returns 0 years, 8 Months and 16 days from today (based on the formula in B2.
A2=15-Mar-23
B2 = =IF(G5,DATEDIF(G5,TODAY(),"y")&" Years, "&DATEDIF(G5,TODAY(),"ym")&" Months and "&DATEDIF(G5,TODAY(),"md")&" Days","")
For example, 15 Mar 23 returns 0 years, 8 Months and 16 days from today (based on the formula in B2.
A2=15-Mar-23
B2 = =IF(G5,DATEDIF(G5,TODAY(),"y")&" Years, "&DATEDIF(G5,TODAY(),"ym")&" Months and "&DATEDIF(G5,TODAY(),"md")&" Days","")