Automatically entering a date based on a date entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to enter a day an employee works and have access automatically enter the date of the beginning of the work week that that date falls into.
 
The following code might help:

=Date()-(Weekday(Date())-2)

Entering that into the default value for a control will
cause the control to show the beginning of the current
week.

If you change the Date() part to any date, it will show
the Monday for the week into which that date falls.

-----Original Message-----
I want to be able to enter a day an employee works and
have access automatically enter the date of the beginning
of the work week that that date falls into.
 
Back
Top