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
Click to expand...
have access automatically enter the date of the beginning
of the work week that that date falls into.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Reoccurring Entries on a Form 3
Excel Monthly Spread sheet. 12
Form for Data Entry 2
Forcing a date entry format of dd/mm/yyyy 1
Access Property sheet data missing also syntax 0
Record selector on a sub-form 3
select date from list 1

Back
Top