Find specific date for day in week

[Guest]

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

 

[Bob Phillips]

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

 

[Guest]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Guest]

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


mike