Hi,
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
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.
swjtx99
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
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.
swjtx99
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 15 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.