DATEADD formula error

1500 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I know nothing about forumlas. I copy examples based on what I can find. I want to update a column based on my ‘start date’ column and my ‘work days’ column. I used this formula and it’s returned an #ERROR!

DATEADD(Startdate +Workingdays)

what should it be?

2 Replies 2

Hi Sandra!

Like this?


The formula for Finish Date below handles the dynamic computation for each row. You can do it with or without the time values showing.


Thank you so much @Bill.French. I wasted hours trying to figure it out because I don’t have the fundamental understanding of formulas. Thank you so much, really appreciate your help.