Calculation of weeks and days

[deepik_a]

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.

[naylinsoe]

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)

[Kal_Lam]

@naylinsoe,

[deepik_a]

Thank you @naylinsoe for the help.