How do I calculate the friday before a date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I have been trying to work with the WEEKDAY function, unsuccessfully. I
have a column of dates, I would like to calculate the Friday before the date
please.

Thank you,
Renee
 
You can use a formula like:
=DATE(YEAR(A1),MONTH(A1),DAY(A1)-MOD(WEEKDAY(A1)-6,7))

The 6 in the MOD(WEEKDAY(A1)-6,7) is the result of the WEEKDAY function on a
Friday, if you have a different setting change it appropiately.

Hope this helps,
Miguel.
 
Thank you both!

Miguel Zapico said:
You can use a formula like:
=DATE(YEAR(A1),MONTH(A1),DAY(A1)-MOD(WEEKDAY(A1)-6,7))

The 6 in the MOD(WEEKDAY(A1)-6,7) is the result of the WEEKDAY function on a
Friday, if you have a different setting change it appropiately.

Hope this helps,
Miguel.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to display next Friday from B1 works except on the Friday itself. 4
How To Calculate the Number of Fridays between two dates. 5
Excel Date of first friday every month 3
Calculating and listing only Monday-Friday in a work schedule 8
Date plus month, year, or years in workdays 5
How to calculate Hours between two dates? 7
Can I get date in this format? 1
VLOOKUP 1st Friday in April and So On 1

Back
Top