How to do =WEEKDAY(DATE();2) as vba?

[knutfh]

I'm stuck with this easy task. I have done some searching, both here in the formus and on Google, but I can't seem to find anything useful. Maybe I'm not using the right query.

As the title suggests, the following formula does the job:

Please Login or Register  to view this content.

Just weekday() I get to work fine, but I need to extract year and month from one place, and then add the day trough a variable.

I've written some pseudocode explaining what I'm after:

Please Login or Register  to view this content.

I've created an example workbook for you to try out.

Basically, the idea is to check if the date built up from the day in Sheet1 and year and month in Sheet2 is a Saturday or Sunday, and if so, hide the entire row.

Your help is really appreciated!

Knut

[knutfh]

I found that I at least need to use DateSerial(), changing the For loop to:

Please Login or Register  to view this content.

But now I get an error message with "object required" for the testDate variable I made.

[Jakobshavn]

Consider:

Please Login or Register  to view this content.

which is the equivalent to the worksheet formula:

=WEEKDAY(DATE(2013,12,25))

[knutfh]

Thanks! I will have a look at this later today.

[knutfh]

I've had a look at it, and got the problem solved myself.

Here is the code for future reference:

Please Login or Register  to view this content.

This Sub also hides any row for a date where the average sum of cells in that row is 0.

[FDibbins]

this would be the regular formula to extract the week day number...
=WEEKDAY(DATE(YEAR(Sheet2!$D$2),MONTH(Sheet2!$D$2),A2),2)