Default Field to closest Saturday

[Sean]

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]

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

 

[Sean]

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.




.