I need to calculate the estimated end date of a project based on working days

beckyw

To calculate the end date of my project, I need a formula that would take today's date and add the number of working days left to it. I keep getting an Invalid data type error.

The Today's Date column and my Estimated project finish date column are both set as Date column types. My Days Left column has it's own formula based on the number of employees assigned to the project and the average time it takes to complete parts of the project (so the '92' will change based on these factors). What am I doing wrong that my finish date keeps giving me an error? Thanks.

bisaacs

Hey @beckyw,

That seems like it should work! Invalid Data Type errors usually means that the data being passed is the wrong type. If the Today's Date column is a Date column, then maybe there's an issue with the Days Left column? Try wrapping the [Days Left]@row in an INT() function to make sure it's converted to a number:

=WORKDAY([Today's Date]1, INT([Days Left]@row))

Hope this helps!

bisaacs

Hey @beckyw,

That seems like it should work! Invalid Data Type errors usually means that the data being passed is the wrong type. If the Today's Date column is a Date column, then maybe there's an issue with the Days Left column? Try wrapping the [Days Left]@row in an INT() function to make sure it's converted to a number:

=WORKDAY([Today's Date]1, INT([Days Left]@row))

Hope this helps!

beckyw

Thanks, @bisaacs ! It worked when adding INT.

And thank you for answering so quickly!