SOLVED

# Date Formula

Occasional Contributor

# Date Formula

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

6 Replies

# Re: Date Formula

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.

best response confirmed by jdilks (Occasional Contributor)
Solution

# Re: Date Formula

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)

# Re: Date Formula

Hi Hans,

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

Thank you,

Jim

# Re: Date Formula

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.

Hi,

Jim

# Re: Date Formula

As variant

``=TODAY()+MOD(8-WEEKDAY(TODAY(),15),7)``