How do I get a future date?
Monday to Friday is my working week.
I want the date of "today" next week
I am rubbish with funtions, so if it is a function please could you supply the whole funtion/ code that i can attach to a command button?

Thank you

smiler44

If you just want the date 7 days from now you can use

Date() + 7

or

DateAdd("d", 7, Date())

or

DateAdd("ww", 1, Date())

Bob Larson, I've got to say you are a genius. Thanmk you.
You have given me such a simple reply. what I found on the web I could not undertsand.

Thank you so very much

smiler44

Bob,
still getting the date 7 days or so from now, is there an easy way with the code you gave me have the date in the format of dd/mm/yy?

Thanks
smiler44

Format(DateAdd("d", 7, Date()), "dd/mm/yy")

Bob, thank you very much.


smiler44