XLSForm: How to calculate the difference between two dates

To calculate the number of months between two dates, enter the following syntax in the calculation column:

int((${today} – ${baby_birthdate}) div 30.44)

The result will be displayed in months. If you want to calculate the result in years, use 365.24 instead of 30.44

difference-2datesxls

Category: Create a New Questionnaire, Questionnaires, Create Questionnaires, Questionnaire > Questionnaire

← Return to search results