Is it possible to find the date for a specific day of the week from a given
date?
For example:
If I have the date 30-07-07 in column A and would like to report the Friday
of the week in column B, the reuslt would be 03/08/07.

Regards

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"The Rook" wrote in message
...
Is it possible to find the date for a specific day of the week from a
given
date?
For example:
If I have the date 30-07-07 in column A and would like to report the
Friday
of the week in column B, the reuslt would be 03/08/07.

Regards

Hi,

Use this

=A1+(WEEKDAY(A1)6)*7-WEEKDAY(A1)+6

Assumes first day of the week is sunday so day 6 is Friday

Mike

"The Rook" wrote:

Is it possible to find the date for a specific day of the week from a given
date?
For example:
If I have the date 30-07-07 in column A and would like to report the Friday
of the week in column B, the reuslt would be 03/08/07.

Regards

Is it possible to find the date for a specific day of the week from a
given
date?
For example:
If I have the date 30-07-07 in column A and would like to report the
Friday
of the week in column B, the reuslt would be 03/08/07.

Unless I'm missing something, this should work...

=A1+6-WEEKDAY(A1)

Rick

You just want to make things simple!! :). nice one


mike

"Rick Rothstein (MVP - VB)" wrote:

Is it possible to find the date for a specific day of the week from a
given
date?
For example:
If I have the date 30-07-07 in column A and would like to report the
Friday
of the week in column B, the reuslt would be 03/08/07.

Unless I'm missing something, this should work...

=A1+6-WEEKDAY(A1)

Rick