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.
8 Replies
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.
Those numbers are manpower for those days on each assignment. those are the number i need to move with the dates in row 11 witch are based off 6G
Checking if a given date is between 2 days is straight forward. The part that's not clear is why the Gantt display shows certain numbers (1-4) and why Saturday is skipped for some assignments but not others.
Those numbers are manpower for those days on each assignment. those are the number i need to move with the dates in row 11 witch are based off 6G
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.
I am not sure what you are trying to do...but, using something like
"=IF(NOW()<=G3,0,2)" where "G3" is the date will replace the "2" with a "0" (or use """" to return a blank cell) when the current date is equal to or greater then the date in "G3"
