Date comparison to get weeks or months value


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,

hi @Saad

see the attached file

calcDates.xls (19.5 KB)

1 Like