# Calculated Date Assistance

#1

I have three fields with values: ProjectStart, DaysInSprint, and Week. I want to compute a sprint start date and sprint end date based on these values.
ProjectStart = 02 April
DaysInSprint = 7
Week = 1, 2, 3, etc

Formula for Sprint Start should be ProjectStart+(DaysInSprint*Week)
Formula for Sprint End should be (DATEADD({Sprint Start}, 10, ‘days’)

However, I can’t even get the Sprint Start to compute correctly. Any ideas where I am going wrong?

Thanks!

#2

Um… why aren’t you using `DATEADD()` for the `{Sprint Start}` calculation?

#3

Because each sprint is a record. Therefore, each week-long sprint starts seven days after the prior one. The DATEADD function adds a set number of days to a date. I need to add start date +7 days for sprint 2, start date +14 days for sprint 3, etc.

The formula I built will work from a computation standpoint. I can’t get the syntax right. Any ideas?

#4

`{Date}+(DaysInSprint*Week)` returns `NaN`.

`DATEADD({Date},{DaysInSprint}*{Week},'days')` returns a date 7*`{Week}` days after `{Date}`.