Spaceballs
02-15-2018, 05:51 PM
Hello, thanks for looking
I have a worksheet with a column full of dates.
I have a cell with a control date
I also need a column with a formula
Column B (starting at cell 5) has dates. The column updates weekly and the number of rows is dynamic. This is where the loop comes in.
C2 has a static date
Column F (starting at cell 5) would have the formula
=IF ($C $2>B5, "over", "in")
I have tried to Frankenstein different code from forums but Excel doesn't seem to like the formula.
Help is greatly appreciated.
I have a worksheet with a column full of dates.
I have a cell with a control date
I also need a column with a formula
Column B (starting at cell 5) has dates. The column updates weekly and the number of rows is dynamic. This is where the loop comes in.
C2 has a static date
Column F (starting at cell 5) would have the formula
=IF ($C $2>B5, "over", "in")
I have tried to Frankenstein different code from forums but Excel doesn't seem to like the formula.
Help is greatly appreciated.