Hello,
I have gone back and forth trying to work out the WEEKDAY function in excel and I'm still pretty confused.
ok, I want to return the friday before or equal to a referenced date.
so if I have 28/2/14 (Friday) in A1 it will return 28/2/14
but if I have 27/2/14 (Thursday) in A1 it will return 21/2/14
Please help
Bookmarks