Find specific date for day in week

T

The Rook

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
 
B

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

Mike H

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
 
R

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.
Click to expand...

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

=A1+6-WEEKDAY(A1)

Rick
 
Top