Calculation of weeks and days

Hi!
I want to calculate weeks and days for the calculation of one variable automatically between todays date and a specific date.
In my data i want to calculate period of gestation in week and day using LMP date and todays date.
I used round((today() - ${lmp}) div 7, 0) for the calculation of week but i also want to calculate days in it.
Please help me in this.
Thanks in advance.

Hi,
for getting day is (today()-${H3}) where H3 specific date.
You can calculate like this, I also attached XLS Form FYI.
Date Calculation XLS Form.xlsx (10.4 KB)

1 Like

@naylinsoe, :bowing_man: :heart: :pray:

Thank you @naylinsoe for the help.

1 Like