Formula to return date of following Friday

D

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
 
R

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--
 
R

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)
 
S

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top