Drewgarry007
Board Regular
- Joined
- Oct 1, 2011
- Messages
- 142
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..
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..