Formula to return date of following Friday
 

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

Answer: Formula to return date of following Friday
 

Formula to return the date of the following Friday:

Explanation:

1. The WEEKDAY function returns a number representing the day of the week (1 for Sunday, 2 for Monday, etc.) for a given date.
2. The TODAY function returns the current date.
3. The IF function checks if the current day (returned by WEEKDAY) is less than or equal to 6 (which means it's not a Saturday or Sunday).
4. If it's not a weekend day, the formula adds 7 days (one week) and subtracts the current day of the week (so that it returns the date of the following Friday).
5. If it is a weekend day, the formula adds 14 days (two weeks) and subtracts the current day of the week (so that it returns the date of the next Friday).

Simply enter this formula into a cell in Excel, and it will automatically update to show the date of the following Friday based on the current date.

Formula to return date of following Friday
 

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

--
RyGuy


"Daniel Bonallack" wrote:

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

Formula to return date of following Friday
 

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)

"Daniel Bonallack" wrote in
message ...
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

Formula to return date of following Friday
 

Try:

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

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Daniel Bonallack" wrote in
message ...
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

Formula to return date of following Friday
 

On Thu, 15 Nov 2007 05:57:01 -0800, Daniel Bonallack
wrote:

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

Formula to return date of following Friday
 

Thanks to everyone!!


"Ron Rosenfeld" wrote:

On Thu, 15 Nov 2007 05:57:01 -0800, Daniel Bonallack
wrote:

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