nearest friday to date and if date is a friday return that friday not the following

Hi there,

I have found several similar formula's on here but not quite what I need.

I need a date in column a to have 60 days added and then to find the nearest Friday to that date. If the date 60 days on is a friday I want to return that friday and not the next.

i.e.
Date in column A is 25/01/2010 date 60 days is 26/03/2010 which is a frdiay so formula should return this date. It should return this date for anything between 19/01/2010 and 25/01/2010.
The formula I was using is:

Please Login or Register  to view this content.

However, this returns the following friday if the date + 60 days is a friday.

Please help

Thanks

Assuming by nearest your mean next - and taking into account that if result is a Friday that date should persist then perhaps:

B1: =A1+60+CHOOSE(WEEKDAY(A1+60,2),4,3,2,1,0,7,6)

Or perhaps =A1+60+MOD(9-WEEKDAY(A1),7)

Your last post makes no sense to me I'm afraid -- hopefully someone else can follow it.

Why would 27/2 + 60 -> 5/3 ?

The result should be 30-Apr - given 27/2 + 60 -> 28/4 which is a Wed - hence +2 is 30-Apr.

Originally Posted by daddylonglegs

I imagine that should be

=A1+60+CHOOSE(WEEKDAY(A1+60,2),4,3,2,1,0,6,5)

Yes, thanks dll... typo on my part - best always to test