Find The Friday Date Of The Month

pradeep_atm · Feb 28th 2008

Hi Excel Gurus,

Is it possible to build a formula to get the last friday date of every month? Last Friday of every month is the period close for us in financial perspective and so is the need.

Hope the issue is clear enough.

Thanks in advance.

VBA Noob · Feb 28th 2008

Re: Find The Friday Date Of The Month

See if links help

http://www.ozgrid.com/VBA/last-n-day-month.htm

http://www.ozgrid.com/forum/showthread.php?t=38981

http://www.ozgrid.com/forum/showthread.php?t=69223

VBA Noob

daddylonglegs · Feb 28th 2008

Re: Find The Friday Date Of The Month

If A1 contains a date, 1st of the month, then this formula in B1 will give the last Friday of that month

=A1+32-DAY(A1+31)-WEEKDAY(A1+33-DAY(A1+31))

format as date

If you want a constantly updating list of "last Fridays" then A1 can always show the 1st of the current month by using

=TODAY()-DAY(TODAY())+1

B1 can show last Friday of current month using formula above and then you can get subsequent last Fridays by using this formula in B2 copied down

=B1+28+7*(DAY(B1+35)>7)

Find The Friday Date Of The Month

Participate now!

Share