How do I calculate the friday before a date?
For a date in A1
=A1-WEEKDAY(A1+1)
"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
|