Forum Discussion
Help with Excel
Hi guys, Can you help me with something ? i want to compare 2 calendar dates in excel , for example: DATE 1 - DATE 2 10/3/2017--2/6/2020 1/17/2019--1/17/2020 9/25/2017--1/25/2019 3/21/2018--3/...
I'd suggest formula rules
=$B2<=EDATE(TODAY(),-3) <- red =($B2>EDATE(TODAY(),-3))*($B2<=TODAY()) <- yellow =$B2>TODAY() <- green
where B2 is first in the range Date 2 cell.