find the first business day of november of LAST year

[daveyc18]

the title says it all

 

[My Aswer Is This]

Is Business day and Weekday the same?

Weekdays are Monday through Friday.

 

[MARK858]

You don't state how you are determining what is a business day but maybe...

Book1
	C
2	Thursday 01/11/2018
Sheet1

Cell Formulas
Range	Formula
C2	=WORKDAY(DATE(2018,11,1)-1,1)

 

[daveyc18]

You don't state how you are determining what is a business day but maybe...

Book1
	C
2	Thursday 01/11/2018
Sheet1

Cell Formulas
Range	Formula
C2	=WORKDAY(DATE(2018,11,1)-1,1)

excluding weekends

 

[MARK858]

Then the post is correct

 

[daveyc18]

Then the post is correct

apologies ...finding it based on today's date

 

[MARK858]

Change the 11 to Month(Today()) and the 2018 to Year(Today()) - 1

 

[MARK858]

Various options....

Book1
	A	B	C	D
1	02/11/2019	Thu 01/11/2018	Thu 01/11/2018	Thu 01/11/2018
2			Thu 01/11/2018	Thu 01/11/2018
Sheet1

Cell Formulas
Range	Formula
A1	=TODAY()
B1	=WORKDAY(DATE(2018,11,1)-1,1)
C1	=WORKDAY(DATE(YEAR(A1)-1,MONTH(A1),1)-1,1)
C2	=WORKDAY(DATE(YEAR(TODAY())-1,MONTH(TODAY()),1)-1,1)
D1	=WORKDAY(EOMONTH(A1,-13),1)
D2	=WORKDAY(EOMONTH(TODAY(),-13),1)

There is also the option in Workday to put a list of holidays so you can cover Public holidays and leave time.