Complicated formula

I need to set the following formula but I'm not sure how to proceed:

DATE + 15 days

I can do this easily enough, but I also need to have the "15th" day fall on
a workday. (so it might actually be "+16" or "+17"). Is there a way to
include the WORKDAY formula in the basic date addition?

Thanks!
--
6-West

one way:

=A1+15+2*(WEEKDAY(A1)=6)+(WEEKDAY(A1)=7)


n article <2C525535-27F5-4A64-89F3-31A14FEBA0A0@microsoft.com>,
"sixwest" <sixwest190@yahoo.com> wrote:

> I need to set the following formula but I'm not sure how to proceed:
>
> DATE + 15 days
>
> I can do this easily enough, but I also need to have the "15th" day fall on
> a workday. (so it might actually be "+16" or "+17"). Is there a way to
> include the WORKDAY formula in the basic date addition?
>
> Thanks!