Start Date/End Date without Workday Function

**RC88** · 11-01-2016, 10:55 AM

Hi,

I'm looking to return the value of "End Date" if I have duration in days and a start date. I'd normally use the workday function, but I want to return the value including work-days.

Ex:
Duration - Start Date - End Date
Value - Date 1 - Return Value

Thanks!

**Special-K** · 11-01-2016, 11:27 AM

Isn't this either

StartDate+Duration

or

WORKDAY(StartDate,Duration)

???

If not please provide example data

**Jonmo1** · 11-01-2016, 12:07 PM

It's just straight addition then..

=A1+B1

A1 = Start Date
B1 = Duration

Start Date/End Date without Workday Function

LinkBack

Thread Tools

Rate This Thread

Display

Start Date/End Date without Workday Function

Re: Start Date/End Date without Workday Function

Re: Start Date/End Date without Workday Function

Thread Information

Users Browsing this Thread

Similar Threads

Adding days to a start date (including weekends & holidays); end date only on workday

[SOLVED] Start date must be next workday and non-holiday after previous task end date

add to start date and excluding days using workday not calculating right

VBA to Calculate Start Date from End Date and Dev Time Using WORKDAY()

[SOLVED]How do I make the workday formula count the start date as the first working day?

[SOLVED] workday function --> calculate START date

workday date function

Bookmarks

Bookmarks

Posting Permissions