Date comparison to get weeks or months value

Hi,

I am working on a mother-child health program, and need to calculate the pregnancy duration of the pregnant woman from the EDD date entered in an earlier question, by comparing it with TODAY() date, and get the answer in WEEKS or MONTHS. Can someone kindly help?

Many thanks,
Saad

hi @Saad

see the attached file

calcDates.xls (19.5 KB)

1 Like