Calculate between 2 dates

Hello everybody,
My need is the following : on a period between two dates 'exmple 1 month) I want to count the number of days according to a status of a member. Example Status 1 = at work, status 2 = sick, status3 = training, ... how can I do this in xlsForm
Thanks for your help:blush:

There is no linear way to do this. Because user cannot select multiple dates on the calendar.

You can do what you want in different ways. I do not know which one is user-friendly and efficient. Check the attached XLS form. If it works for your case please let us know.date_management.xlsx (15.4 KB)

1 Like

Dear Arif,
Thank you very much. It' s a very good solution. That solve my problem.

Kind regards