end date

[ADK]

If I input a start date in a cell, and give the number of days required to
complete the task in another cell.......How can I compute the end date
omitting the weekends (Saturday and Sunday)?

thanks

 

[T. Valko]

Try this:

A1 = date
B1 = number of days

=WORKDAY(A1,B1)

Format as DATE

Note that the WORKDAY function requires that the Analysis ToolPak add-in be
installed.

Biff

 

[ADK]

so easy, thanks

Try this:

A1 = date
B1 = number of days

=WORKDAY(A1,B1)

Format as DATE

Note that the WORKDAY function requires that the Analysis ToolPak add-in
be installed.

Biff

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

so easy, thanks