Hi,

I'm trying to insert the follwing line in a cell.
"Please send the file on MM/DD/YYYY"

I have written the following code, in which the date will be pulled from cell "B1".

Sub autotext()
Worksheets("Sheet1").select
Range("D1").Value = "Please send the file on" & Space (1) & Format(Worksheets("Sheet1").Range("B1")) &
End Sub

But i want the date to be a working day. I have a list of holidays on my other worksheet. So how do i tell excel to put a working day, using vba?

Thank you.