Forum Discussion
Solved
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)
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.