Weekdays only formula

[Drewgarry007]

Hi there,

when I put this formula through a loop I want ti to only to return weekdays not seekends:

ActiveCell.Offset(0, 3) = "=today() + 1"

So when I run the loop on a friday it brings back mondays date, instead of saturdays date..

 

[Andrew Poulsom]

Try:

ActiveCell.Offset(0, 3) = "=WORKDAY(TODAY(),1)"

In versions of Excel prior to Excel 2007, the WORKDAY function is in the Analysis ToolPak Add-In, which must be installed.

 

[Rick Rothstein]

when I put this formula through a loop I want ti to only to return weekdays not seekends:

ActiveCell.Offset(0, 3) = "=today() + 1"

I am curious as to what your loop would look like... TODAY()+1 will always be tomorrow's date no matter how many cells you place that formula in.

 

[Drewgarry007]

Awesome this worked thanks!!