Saturday of the week

[Guest]

I obtain the Monday of a given week with the following:

=Format(DateAdd("d",-(Weekday([txtDate])+5) Mod 7,[txtDate]),"dd-mmm-yy")

courtesy of this forum and it works a treat, but can't for the life of me
obtain the Saturday, any ideas would be appreciated.

Cheers Ross

 

[Guest]

Hi Ross,

Try this:
=Format([txtDate]-(Weekday([txtdate])-7),"dd-mmm-yy")



Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I obtain the Monday of a given week with the following:

=Format(DateAdd("d",-(Weekday([txtDate])+5) Mod 7,[txtDate]),"dd-mmm-yy")

courtesy of this forum and it works a treat, but can't for the life of me
obtain the Saturday, any ideas would be appreciated.

Cheers Ross