Question.

I'm creating a small app that allows certain users to start a process for for other users on the days in a given week. They specify the week number and then I would like to get the first five dates of that week. Only working days are needed but if it includes the weekend I can work around that. I'm working with a week starting on Monday in this case.

Sure I can get the week number using the Weeknumber() UDF like below but is there a way to get the dates belonging to that week? E.g. if I specify week 31 of this year I would like to have July 28th, 29th, 30th, 31st and August 1st.

I really s#ck at date math in scripts so any help is greatly appreciated.

 Code:
Break on

Weeknumber()

Sleep 5


Edited by Mart (2014-07-30 09:42 PM)
_________________________
Mart

- Chuck Norris once sold ebay to ebay on ebay.