If Date is last working day of the month

[mrdzyyyrawr]

I need help with a formula that checks if a date in the cell above is the last WORKING day of a month and ideally also checks against a list of public holidays I have. Saturdays are classed as working days. Any help would be appreciated. Thanks.

 

[Marcelo Branco]

Maybe something like this...

Dates as dd/mm/yyyy

[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]

A​

[/TD]
[TD="bgcolor: #DCE6F1"]

B​

[/TD]
[TD="bgcolor: #DCE6F1"]

C​

[/TD]
[TD="bgcolor: #DCE6F1"]

D​

[/TD]
[TD="bgcolor: #DCE6F1"]

E​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

1​

[/TD]
[TD]

Dates --->​

[/TD]
[TD]

10/04/2018​

[/TD]
[TD]

30/03/2018​

[/TD]
[TD]

31/01/2018​

[/TD]
[TD]

30/09/2018​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

2​

[/TD]
[TD]

Is it last Working Day?​

[/TD]
[TD]

No​

[/TD]
[TD]

No​

[/TD]
[TD]

Yes​

[/TD]
[TD]

No​

[/TD]
[/TR]
</tbody>[/TABLE]


Formula in B2 copied across
=IF(B1=WORKDAY.INTL(EOMONTH(B1,0)+1,-1,11,Holidays),"Yes","No")

Where Holidays is a named range that contains your list of public holidays.

Hope this helps

M.

 

[mrdzyyyrawr]

That's exactly what I wanted. Thanks!