View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico Miguel Zapico is offline
external usenet poster
 
Posts: 95
Default How do I calculate the friday before a date?

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.

"Renee" wrote:

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