Check date status in list

[YasserKhalil]

Hello everyone

I have dates in range and I would like to check two conditions and if the both conditions are True then the date is True
First condition is to be the last day of the month
Second condition the day not to be equal to Friday or Saturday or Sunday

** if the last day was Friday or Saturday or Sunday then to get the next date as True.

I have tried to adjust that but with no success

I am trying UDF like that

Please Login or Register  to view this content.

This is OK for getting the last day as True but what if the last day was Friday or Satruday or Sunday. In this case I need to get the next date as True

[YasserKhalil]

I could figure it out in that way .. and I welcome more solutions

Please Login or Register  to view this content.

[YasserKhalil]

And this is the UDF

Please Login or Register  to view this content.

[sintek]

so if date is last day of month and date is not Fri or Sat or Sun then true else false?

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot Sintek for solution
Have a look at the sample to see the issue from my side

[sintek]

Shouldn't A21 be false...Is not end of month

[YasserKhalil]

No it should be True as the last day in the month was Friday so I looped till the date is not equal for the Friday or Saturday or Sunday
So here the date 30/01/2020 as it is Thursday ..

[sintek]

Sorry guess I misunderstood the criteria...
If the date falls on a Thursday and it is close to month end then that day must be month end???

[YasserKhalil]

I have taken the previous working day and if I want to change to the next working date, I would change - to + in the x=x-1 line