something like this should do the trick

Dim mydate As String
mydate = Format(Date + 2, "dddd")
If mydate = "Saturday" Then mydate = Format(Date + 4, "dddd")
If mydate = "Sunday" Then mydate = Format(Date + 4, "dddd")


"JillC" wrote:

How can I ensure that if I add a number of days to a date (which is a working
date) the result will also be a work date
--
Thanks, Jill