Monday to Friday

[diego_vazquez]

Hi everyone.

My problem is that I have an Auto Selection when I open the document, that selects the previous day automatically and a macro send the report also automatically. The problem is that when the weekend is the previous day, the auto select have no data, and the report is not sent correctly.

My question is if is there any code to auto select the friday when is monday,insted the sunday so I dont have to re-send the reports manually every week.

Thanks in advance

[andrespa]

Hi Diego, I think that if you modified your macro code you could achive this. Could you please post the macro code to have a look.

Cheers,

Andrés

[swuehl · Accepted solution]

Use

=FirstWorkDate(Today()-1,1)

to retrieve the previous working day.

[diego_vazquez]

Thank you very much swuehl, that worked!

swuehl escribió:

Use

=FirstWorkDate(Today()-1,1)

to retrieve the previous working day.

[oknotsen]

If your question is now answered, please flag the Correct Answer.

If not, please make clear with what part of your question you still need help .

[diego_vazquez]

thank you for the advise!