Feb 04 2021 07:54 AM
How do I get the date to = the last Friday of the month?
Feb 04 2021 08:16 AM
That could be
=EOMONTH(A1,0)-WEEKDAY(EOMONTH(A1,0),15)+1
if in A1 any date within given month. Or something like this, depends on how do you define year and month.
Feb 04 2021 08:18 AM
Solution1) If you want the last Friday in the month of the date that is in cell B2:
=EOMONTH(B2,0)+1-WEEKDAY(EOMONTH(B2,0)-5)
2) If you want the last Friday in the current month:
=EOMONTH(TODAY(),0)+1-WEEKDAY(EOMONTH(TODAY(),0)-5)
Feb 04 2021 09:29 AM
Hi Hans,
Thank you for your help.
Can you help me with the formula for the first Friday of the month?
Thank you,
Jim
Feb 04 2021 09:45 AM
use =CEILING(EOMONTH(TODAY(),-1)-5,7)+6 t o get the first Friday of current month you can replace today() to refer cell to get first Friday of that month.
Feb 04 2021 08:18 AM
Solution1) If you want the last Friday in the month of the date that is in cell B2:
=EOMONTH(B2,0)+1-WEEKDAY(EOMONTH(B2,0)-5)
2) If you want the last Friday in the current month:
=EOMONTH(TODAY(),0)+1-WEEKDAY(EOMONTH(TODAY(),0)-5)