Forum Discussion
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.
When the date in yellow changes. I need the numbers in the Cell to move with the row date
I guess my last try based on what you have given...similar to the first formula, if you use "=if(H$12>=$G$6$,2,"")" This will leave the "Green" or "Gray" cells blank in the column if the date in row "H" is prior to the date in "yellow" cell "G6".