Saturday

P

PeterK

I would like to have a field default allways to the next
saturday. How do I do this using the Date() function?

THX
 
R

Rick Brandt

PeterK said:
I would like to have a field default allways to the next
saturday. How do I do this using the Date() function?
Click to expand...

Try this...

NextSaturday: DateAdd("d", 8-(Weekday(Date(),vbSaturday)),Date())
 

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 implement two shifts per day with multiple teams 0
Calculate Day/Date Help 2
Format Dates: Sunday, Feb 1, 2009 to Saturday, Feb 7, 2009 4
Defaulting to Saturday date 1
Creating a date from week number, day number and year value 1
Limit to List Setting + Insert Date Using Popup Calendar 5
Testing a cell value for a specific weekday. 4
Filter dates by Saturday 1

Top