Calculate Next Mondays Date

  • Thread starter Thread starter Deano
  • Start date Start date
D

Deano

Does anyone know how to calculate the Nearest/Next Mondays
date from a given date. eg I want a user to enter a date
into a field. I then want the system to calculate the
next/nearest Monday to that by pressing a command button.

Thanks in Advance
 
Thanks that worked great.

However, could you calculate it to go forward ???

thanks again
Allen Browne said:
Try something like:
[TheDate] - Weekday([TheDate], 2) + 1

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Deano said:
Does anyone know how to calculate the Nearest/Next Mondays
date from a given date. eg I want a user to enter a date
into a field. I then want the system to calculate the
next/nearest Monday to that by pressing a command button.

Thanks in Advance
Click to expand...
Click to expand...
 
Experiment with it until you get what you expect.
For example, changing the "+1" to "+8" will roll it forward a week.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Dean Simpson said:
Thanks that worked great.

However, could you calculate it to go forward ???

thanks again
Allen Browne said:
Try something like:
[TheDate] - Weekday([TheDate], 2) + 1


Deano said:
Does anyone know how to calculate the Nearest/Next Mondays
date from a given date. eg I want a user to enter a date
into a field. I then want the system to calculate the
next/nearest Monday to that by pressing a command button.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top