Calculate age in months

[darkobird84]

Hi

I have a spreadsheet which shows pregnant mums due dates.I want to calculate how old in months the babies are as of today if they were born on their due dates.Anyone help ?see attached.

[Colin Legg]

Hi,

Try this:

Please Login or Register  to view this content.

All of the "How Old" will be blank except for the last one because the due dates are before today's date.

If you want today's date to automatically update, you can use the TODAY() function:

Please Login or Register  to view this content.