I asked some help today in previous post to have a formula that uses TODAY() function to generate last week Fridays date regardless what week of the day it happens to be and I got answer:
This is working brilliantly. When I got the answer hoped I figure out rest of it. Which I did as long as I only needed to have any other weekdays date of previous week. But now I would also like to have a code that generates the current week Fridays date again regardless what the day and date is. I tried to mess about for the last hour and a half and cant figure out how to achieve this.
So lets say today is Monday the 31/01/2011, it would then generate the date 04/02/2011.
If today would be Thursday the 03/02/2011 it would still generate the date 04/02/2011.
If today would be Friday the 04/02/2011 it would still generate the date 04/02/2011.
But if today would be Saturday the 05/02/2011 it would now generate the date 11/02/2011.
Can anyone help me with this. Its driving me mad.
Cheers
Bookmarks