Hi,
So what I'm looking at doing is getting dates for the current weeks Monday and Saturday. I think what I'd need to do is look at todays date say that came back as Thursday 19/1/2012, I then would want it to get me Monday's date and Saturday's date and put them in the necessary field for each. I assume VBA would be the best way to do this. Sorry if I didn't explain it well.
Many thanks.
So what I'm looking at doing is getting dates for the current weeks Monday and Saturday. I think what I'd need to do is look at todays date say that came back as Thursday 19/1/2012, I then would want it to get me Monday's date and Saturday's date and put them in the necessary field for each. I assume VBA would be the best way to do this. Sorry if I didn't explain it well.
Many thanks.