Identifying the last Friday of the Month

[JayB0730]

Hello,

I have a formula where I want to look up whether Today() is >= the 15th of the month AND less than the last Friday of the current month. I've been at it for hours and using May as an example where Today = May 30th, the formula I've been using keeps coming up as true. And that is not the case since the last Friday of the month is May 26th.

Any help is greatly appreciated!

 

[Phuoc]

Try this

=AND(DAY(TODAY())>=15,TODAY()<WORKDAY.INTL( EOMONTH(TODAY(),0)+1,-1,"1111011"))

 

[JayB0730]

Sometimes a quick walk away from the screen can help. I think I figured it out -- in case anyone is looking for the same thing:

=WORKDAY.INTL(EOMONTH(Today(),0)+1,-1, "1111011") results in 5/26/2023

1. EOMONTH(Today(),0)+1 results in 6/1
2. Adding WORKDAY.INTL(6/1, -1. "1111011") tells the system to go back to the first workday. "1111011," says to keep skipping weekend dates until you reach Friday which is not defined as a weekend by the "0". And "1111011" refers to Monday - Sunday.
   1. 6/1 - Starting point
   2. 5/31 - Wednesday (skip - "1')
   3. 5/30- Tuesday (skip - "1')
   4. 5/29 - Monday (skip - "1")
   5. 5/28 - Sunday (skip - "1")
   6. 5/27 - Saturday (skip) - "1")
   7. 5/26 - Friday (STOP - "0")

 

[JayB0730]

That's too funny. I just figured it out and it matches yours. Thank you so much for confirming!