Forum Discussion
Date Formula
How do I get the date to = the last Friday of the month?
1) 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)
6 Replies
1) 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)
Hi Hans,
Thank you for your help.
Can you help me with the formula for the first Friday of the month?
Thank you,
Jim
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.
That could be
=EOMONTH(A1,0)-WEEKDAY(EOMONTH(A1,0),15)+1if in A1 any date within given month. Or something like this, depends on how do you define year and month.
