Calculating Gestation age in Weeks and days based on given LNMP

Hello all, I would like to be able to calculate the Gestation age and the result to be displayed in weeks and days i.e. 20 Weeks and 4 days, based on LNMP and current date. How can I be able to implement this based on a hypothetical LNMP date of 20/06/2020?


Hi @kabalaandrew
First you need to calculate days between two dates.
Then you need to calculate weeks ${days_between_two_dates} div 7
And calculate days left ${days_between_two_dates} mod 7

and you can display the result. I'm attaching a sample form: calcDates.xls (6 KB)

1 Like

Thanks @Grzesiek2010 for your swift response with an example. It completely solved my problem. I do really appreciate! Cheers and stay safe. :slight_smile: