Hi all,
What would be the formula I need to find the following Friday from a date? I figure that it would be a combination of WEEKDAY, DATE and CHOOSE but I can't get my head around it.
I have read Dave's posts on finding the last Friday of a month etc. but I can't work out how to get the next occurring Friday from a particular date (not just the last). I.e. if cell D2 has 13/08/2008, I want E2 to have 15/08/2008 since that is the next occurring Friday.
Thanks in advance.
Averil[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]OK, I have the following now:
=D2+(WEEKDAY(D2)>6)*6-WEEKDAY(D2)+6
However, this doesn't work properly if a Saturday date is entered (it puts the next Thursday in). My brain is in overload this week so I apologise if this is an extremely simple question.
Cheers,
Averil
