Skip to main content

DATEADD formula error

  • September 19, 2019
  • 2 replies
  • 5 views

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

Forum|alt.badge.img+19
  • Inspiring
  • September 19, 2019

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.


  • Author
  • New Participant
  • September 24, 2019

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.