Check if Week commencing contains last Friday in month

[orangebloss]

Hi all

I'm trying to work out if it's possible to calculate whether or not a given week contains the last Friday and if so place some kind of marker to flag this up so that I can determine which reporting month it should be in. Any help appreciated!

W/C	01/01/2018	08/01/2018	15/01/2018	22/01/2018	29/01/2018
Week Num	1	2	3	4	5
Contains last Friday of month?	No	No	No	Yes	No
Reporting Month	Jan	Jan	Jan	Jan	Feb

 

[steve the fish]

Heres a couple of ways. They both rely on your date provided being a monday!

=IF(EOMONTH(B1,0)-WEEKDAY(EOMONTH(B1,0)-6)=B1+4,"Yes","No")
=IF(AND(MONTH(B1+11)<>MONTH(B1),MONTH(B1+4)=MONTH(B1)),"Yes","No")

 

[orangebloss]

Thanks! I will give it a go!