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()

Me.txtDate = Date - 1
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!