Formula to subtract one column from another
Posted on 2013-01-07
I need to put a formula into a blank column that subtracts the date in another column from Today and returns the number of workdays. This is a line in a VBA macro.
The catch is that it need to do it for every row where column A is not "blank/null".
To restate, every row where column A is not blank, subtract the date from column G and insert the number of workdays into column H.
I think it might start something like this?
Sheets("Sheet1").Range("H2:H" & Range("A2").End(xlDown).Row).FormulaR1C1 = "=?"
I'm just not sure what should be where the =? is. I couldn't say "=Today()-G" without specifying a row# right?
Any help would be appreciated.