returning the first workday of the year

[Lino]

Hello,

using vba is it possible to return the first work day of the year if you know the year?

so for example:

I want to know the first workday of the year for 2003. So could I somehow say give me the first workday of the year for january 2003?

thanks,

Lino

 

[Oaktree]

It depends on your holiday schedule. In your example, 1/1/2003 was a Wednesday, so your company's first workday could have been anywhere from 1/1/2003 to 1/6/2003

 

[Aladin Akyurek]

Hello,

using vba is it possible to return the first work day of the year if you know the year?

so for example:

I want to know the first workday of the year for 2003. So could I somehow say give me the first workday of the year for january 2003?

thanks,

Lino

=WORKDAY(DATE(A1-1,13,0),1,Holidays)

A1 houses 2003, the year of interest. Holidays is a range that houses the holiday dates of the relevant year, that is, that of A1.