Default Field to closest Saturday

Sean · Nov 6, 2003

Hello,

I have a field on a form that I would like to default to
the closest Saturday coming up (If it is Sunday I don't
want it to default to the day before). How would I do
this? Thanks for your help!

-Sean

Allen Browne · Nov 6, 2003

=Date() - Weekday(Date()) + 7

Sean · Nov 6, 2003

That worked great, thanks!

-----Original Message-----
=Date() - Weekday(Date()) + 7

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

.