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".
Ok...if I am reading this right...you want cell "F11" to start off with a Monday based on cell "G6". So cell "F11" would read "=G6-Weekday(G6,2)+1" then you could enter into the balance of the cells in the "F" row starting with "F12" insert "=F11+1", then in "F13" "=F12+1", etc.
