Book1 | |||
---|---|---|---|
C | |||
2 | Thursday 01/11/2018 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2 | =WORKDAY(DATE(2018,11,1)-1,1) |
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)
apologies ...finding it based on today's dateThen the post is correct
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) |