Formula to return date of following Friday

[Daniel Bonallack]

Excel 2002
I would like a formula that returns the date of the following Friday.

So if today is 11/14/2007 (american version of date), then it would return
11/16/2007

If today is a Friday, then it should return the next Friday.

Thanks in advance!
regards
Daniel

 

[ryguy7272]

Any of these should work for you:
=TODAY()-WEEKDAY(TODAY(),1)+6

=TODAY()-WEEKDAY(TODAY()-6)+7

=TODAY()+6-MOD(WEEKDAY(TODAY())+7,7) < -- Note: if today is Friday, it
shows today's date

=TODAY()+7-MOD(WEEKDAY(TODAY())+1,7) < -- Note: if today is Friday, it
shows today's date


Hope that helps,
Ryan--

 

[Ron Coderre]

With a date in A1

This formula returns the date of the NEXT Friday:
=A1-WEEKDAY(A1)+6+(WEEKDAY(A1)=6)*7

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

 

[Sandy Mann]

Try:

=A1-WEEKDAY(A1-4,2)+8

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Ron Rosenfeld]

Excel 2002
I would like a formula that returns the date of the following Friday.

So if today is 11/14/2007 (american version of date), then it would return
11/16/2007

If today is a Friday, then it should return the next Friday.

Thanks in advance!
regards
Daniel

=A1+8-WEEKDAY(A1+2)
--ron

 

[Daniel Bonallack]

Thanks to everyone!!

=A1+8-WEEKDAY(A1+2)
--ron