Last day of the week code?

[ielmrani via AccessMonster.com]

Hi All,
I have a field (in a query) called Start date.
Our company work days are Friday to Saturday. I am looking for a way to add
a field called End date to generate the last day of the week date(which is
Saturday).
For example:

Start day End day

05/15/2006 05/20/2006
05/17/2006 05/20/2006
05/19/2006 05/20/2006

05/24/2006 05/27/2006
05/25/2006 05/27/2006

thanks

 

[ielmrani via AccessMonster.com]

Correction...
Our company work days are Monday to Saturday.
Thanks

 

[ielmrani via AccessMonster.com]

I got it.
Here is the formula in case anybody wants to know:

[End Day]: [Start Date] + (7 - Weekday([Start Date]))


Thanks

Ismail