VBA Function Dateadd not working with "w" weekday arithmetic?

[brucemc777]

Office 365...

Seems I am getting the exact same results when I run:

DateAdd("w",7,DATE)

or

DateAdd("d",7,DATE)

in that the identifier for a weekday, "w", is not skipping weekends.

As I didn't see anyone else having this problem, either I am doing something wrong or no one else cares!

Can anyone either suggest how I might be causing the problem or suggest a nice fix?

Thank-you!

[Pri_R]

Hi

If you trying to get a date 7 working days later, you can try the workday function

=WORKDAY (start_date, days, [holidays])

Hope this helps

[brucemc777]

Thank-you!

Yes, I was hoping that I just was doing something stupid, but it looks like I will need to call in Application.WorksheetFunction and run it that way if I can't find fault in what I'm doing!

[EssoExplJoe]

It's up to you but don't see the problem using the following to add 7 workdays to the current date (leave out the cvDate if you only need the dateserial number:

Please Login or Register  to view this content.

[brucemc777]

Yup, I am running the same for now. I was hoping there was a problem in my methodology or a setting as I have to believe that the native VBA functions run more efficiently (most of the time...) than application,worksheetfunction calls. Will have to post somewhere to let them know they have something more to fix besides the latest preview of W10, which crashes every time I tried to use my mouse...