Userform Textbox Date - Subtract Weekend

[Nu2Java]

Hello,

I have a userform that I use to run some data for the previous day which is simple enough for me to use on UserForm_Initialize()

Please Login or Register  to view this content.

Is there an easy way to format it so if the form runs on Monday, it subtracts the weekend so it enters Friday's date ?

Thanks for any help!

[rvasquez]

Hello there try this

Please Login or Register  to view this content.

[Nu2Java]

rvasquez,

This works like a charm... just what I needed. Thanks very much for your time and help!