Course Delivery Date formula

jball_gt

I have a formula that seems simple, but for some reason it's calculating an extra day. There are three columns and the first is duration in days, the next is delivery date, then the third is the end date. What should be happening is the delivery date should be counted as one day, then the calculations should be added to that.

So in the first row the duration in days is 1, the estimated delivery date is 6/28/2024, so the course end date should be 6/28/2024 which is one day. (it's adding the extra day instead of counting the start date as 1 day.

The next rows are doing the same thing, the bottom row shows a duration of 2 days, so the Estimated Delivery Date is 10/29/2024, and the estimated end date should be 10/30/2024 and not 10/31/2024.

The formula used =[Estimated Course Delivery Date]@row + [Duration (in days)]@row

I've tried a few things but none seem to be working.

Also - Is there a way to have it ignore weekends and only use work days?

jball_gt

https://community.smartsheet.com/discussion/comment/431819#Comment_431819

Thanks Paul, it didn't include the work days question, but it got me on the track. I ended up using

=WORKDAY([Estimated Course Delivery Date]@row, [Duration (in days)]@row - 1)

That seemed to calculate it out correctly.

Paul Newcome

You would just subtract 1 from the final output.

=[Estimated Course Delivery Date]@row + [Duration (in days)]@row - 1

You can use the NETWORKDAYS function to account for only workdays.

https://help.smartsheet.com/function/networkdays

jball_gt

https://community.smartsheet.com/discussion/comment/431819#Comment_431819

Thanks Paul, it didn't include the work days question, but it got me on the track. I ended up using

=WORKDAY([Estimated Course Delivery Date]@row, [Duration (in days)]@row - 1)

That seemed to calculate it out correctly.