Calculate end date

**BRISBANEBOB** · 10-14-2011, 06:12 PM

I am scheduling a project in Excel - if I have the start date and the number of days effort required to complete a task, how do I calculate the end date ignoring all weekends?

**daddylonglegs** · 10-14-2011, 06:14 PM

Try WORKDAY function

=WORKDAY(A1,B1)

where A1 is start date and B1 number of days

**alansidman** · 10-14-2011, 06:19 PM

Try the =Workday function in Excel

**BRISBANEBOB** · 10-14-2011, 06:21 PM

Thanks - appreciated

Calculate end date

LinkBack

Thread Tools

Rate This Thread

Display

Calculate end date

Re: Calculate end date

Re: Calculate end date

Re: Calculate end date

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions