Date Formula

Occasional Contributor

How do I get the date to = the last Friday of the month?

6 Replies


That could be


if in A1 any date within given month. Or something like this, depends on how do you define year and month.

best response confirmed by jdilks (Occasional Contributor)


1) If you want the last Friday in the month of the date that is in cell B2:




2) If you want the last Friday in the current month:




@Hans Vogelaar 

Hi Hans,


Thank you for your help.


Can you help me with the formula for the first Friday of the month?


Thank you,


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.







Thank you for your help.




As variant