Networkdays

[hh2020]

Hi,

I am new to VBA/Macros and would like some to help me understand what is the equivalent of NETWORKDAYS(TODAY()-RC[-1],TODAY())" with SQL?
is this to calculate only the business days (skip weekends and holidays?) the different between TODAY()-RC[-1] and Today() , but I don't understand what is TODAY()-RC[-1] means?

Thank you

[6StringJazzer]

NETWORKDAYS gives you the number of working days. If you look it up in Excel help you will get an excellent description. The specific formula you showed gives the number of working days from yesterday to today. Note that if you want holidays to be excluded to you have a create of list of holidays and use them for the third argument, which is optional.

I don't know what your question has to do with VBA or SQL.

TODAY()-RC[-1]

is an expression that uses the R1C1 form of cell addressing. It means to start with today's date, then subtract the number found in the cell in the same row and one column to the left of whatever cell this formula is in.

[hh2020]

Thanks for your prompt response. The reason I post this message in VBA because I am reading the macro with VB script and not sure if NETWORKDAYS is from VB also. So with the formula I provided shows the number of working days from yesterday to day, it has nothing to do with holidays correct?

Thanks

[6StringJazzer]

NETWORKDAYS is not a built-in VBA function. You can refer to Application.WorksheetFunction.Networkdays.

The way you wrote the formula, it does not take into account holidays. This is what the formula looks like in B2, if you have a list of 8 holiday dates in column C:

Please Login or Register  to view this content.