end date
 

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

end date
 

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" wrote in message
...
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

end date
 

so easy, thanks

"T. Valko" wrote in message
...
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" wrote in message
...
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

end date
 

You're welcome. Thanks for the feedback!

Biff

"ADK" wrote in message
...
so easy, thanks

"T. Valko" wrote in message
...
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" wrote in message
...
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