Forum Discussion

Copper Contributor

Jun 08, 2026

How do I have the Numbers in the Green Move with the Dates

I I'm trying to have the numbers in the green or gray area change when the date changes. What formula should I use to achieve this? Please help.

Brass Contributor

Jun 11, 2026

Since we need to include columns "C" and "D" in the formula, in cell "G13" I would enter

=IF(AND(G$10<>"S",$C13>=$G$6),IF(AND(G$12>=$C13,G$12<=$D13),2,""),"")

then copy that cell thru out the rest of the sheet as needed.