Help

DATEADD formula error

1736 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sandra_Michaeli
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?

image.png

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

image.png

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.