Beginning of week

  • Thread starter Thread starter Jaz
  • Start date Start date
J

Jaz

Is there a formula that can tell me what the beginning of the week is? For
example, Today is 4/10/07. The beginning of our week is Sunday so I want it
to return a value of 4/8/07.

Thanks,
Jasper
 
Replace [IncidentDate] with your date field.

DateAdd("d",-Format([IncidentDate]-1,"w"),[IncidentDate])
 
THANKS!
KARL DEWEY said:
Replace [IncidentDate] with your date field.

DateAdd("d",-Format([IncidentDate]-1,"w"),[IncidentDate])
--
KARL DEWEY
Build a little - Test a little


Jaz said:
Is there a formula that can tell me what the beginning of the week is? For
example, Today is 4/10/07. The beginning of our week is Sunday so I want it
to return a value of 4/8/07.

Thanks,
Jasper
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

Determine 1st week date of the week 4
Determine what week a day is in 1
Week of 8
YouTube error: "If playback doesn't begin shortly, try restarting your device" 0
Moving Sum Omitting Low Values 11
Fiscal Year Week Number Calculation with a twist.... 6
Show prior week in the Date Picker 2
Calculate date with condition 1

Back
Top