I am creating Project Request submission form. I want to calculate the project duration by using DATEDIF formula on "Start Date" and "Finish Date" date fields. I positioned all three fields into section and called it "Expected Duration" and creating the following formula:
=DATEDIF(Project_Duration.Start_Date_Value,Project_Duration.Finish_Date_Value,"m")
I also tried FLOOR formula as follow:
=FLOOR((Project_Duration.Finish_Date_Value-Project_Duration.Start_Date_Value)/365.25,1)&"year(s),"&FLOOR(MOD((Project_Duration.Finish_Date_Value-Project_Duration.Start_Date_Value)/365.25,1)*12,1)&"month(s),"&FLOOR(MOD((Project_Duration.Finish_Date_Value-Project_Duration.Start_Date_Value)/30.4375,1)*30.4375,1)&"day(s)"
In both cases i receive an error stating that the formula contains referencing errors and then it references the variables associated with the date fields. I checked the variables names and everything seems to be fine. I would appreciate if anyone can help troubleshoot this error. Thanks.