Conditional Formatting two dates:

[FGaxha]

Hi Master,
I need help to calculate with conditional formatting between two dates:
If B2:B8-G2 =<12month highlight cells in red and column C red flag including number of month, not number on C

 

[etaf]

=AND($B2<>"",$B2<DATE(YEAR("1/1/2023")+1,MONTH("1/1/23"),DAY("1/1/23")))

 

[FGaxha]

Hi there,
Again please:
I want to start counting as 1/1/20203 instead of Today()??

 

[etaf]

=IF(B2>TODAY(),DATEDIF(TODAY(),B2,"m"),DATEDIF(B2,TODAY(),"m")*-1)

=IF(B2>DATEVALUE("1/1/23"),DATEDIF(DATEVALUE("1/1/23"),B2,"m"),DATEDIF(B2,DATEVALUE("1/1/23"),"m")*-1)

 

[FGaxha]

Thank you

 

[etaf]

welcome