To calculate the saturday 15 weeks prior to a date ?

[Andy787878]

Is it possible for Excel to calculate the date which falls on a saturday, 15 weeks prior to a date.
e.g: if date is 11-11-06, i'd like Excel to return 29-07-06.
eg2 if date is 12-11-06 (or any date between 12-11 and 18-11), i'd like Excel to return 05-08-06.

Hope that makes sense... Many thanks,
Andy

 

[Andy787878]

I guess the easiest way is for Excel to work out the saturday on or after the original date, and subtract 105 (15*7) days.... but i'm stuck with the first bit.

 

[barry houdini]

If your date is in A1

=A1-WEEKDAY(A1)-98

 

[Andy787878]

Magic. Thank You.