Date Value: Week Begin

  • Thread starter Thread starter Bernie
  • Start date Start date
B

Bernie

I'd like to use an expression to identify the Week
Beginning date (using Monday) of a given entered date
value.

Users can enter any day of the week, but I would like to
translate that to the Monday date.

Bernie
 
Use the DateAdd function.

DateAdd("d",2-Weekday([SomeDate]),[Somedate])

Sorry, I can't be any more specific that that.
 
Worked great! Thanks!
Bernie
-----Original Message-----
Use the DateAdd function.

DateAdd("d",2-Weekday([SomeDate]),[Somedate])

Sorry, I can't be any more specific that that.
I'd like to use an expression to identify the Week
Beginning date (using Monday) of a given entered date
value.

Users can enter any day of the week, but I would like to
translate that to the Monday date.

Bernie
Click to expand...
.
Click to expand...
 

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

How to reference all dates to a "Monday" 4
payroll weeks / varying first day and week of the year 2
Excel Excel VBA Script help 0
Want the week number of a given date 5
Group by week 3
Extract data from previous week, previous two weeks, etc. 2
Week number to Monday of week 3
Need Monday date for given week number 4

Back
Top