Find specific date for day in week

  • Thread starter Thread starter Guest
  • Start date Start date
G

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