Age in Months taking data from two columns

[Maid Marion]

Hello,
I hope you can assist me, I have read through the many postings similar to this but haven't found a solution for me.
To explain:-
I have a spreadsheet which has a child's month of birth in column F and year of birth in Column G, the data is selected from a list
I also have 2 cells at the top, one showing the current month cell K3 =MONTH(TODAY()) and the other the current year cell L3 =NOW().
I want in a third column to be able to calculate the child's age in months.
I can do this using a date of birth but I am not allowed to record that. I can also do this if I manually change the current month and year but I wanted that to be automatically populated.

I hope that makes sense, any help would be very much appreciated,
many thanks
Maid Marion

[martindwilson]

do you assume all children start at 1st of month? so its inclusive 1/1/2012 or 31/1/2012 to month of today would be the same?
=DATEDIF(DATE(G1,F1,1),today(),"m")

[Maid Marion]

Yes, it doesn't matter where in the month the birthday falls.

Thanks for replying so quickly

[martindwilson]

hmm maybe
=DATEDIF(DATE(G3,F3,1),EOMONTH(TODAY(),0),"m") that calculates from 1 of any month to last day of current month
if you want up to last day of last month
=DATEDIF(DATE(G3,F3,1),EOMONTH(TODAY(),-1),"m")

[Maid Marion]

Wow, thank you so much and so quick. I have been struggling for hours!
I assume I can now get rid of the current month and current year cells as they are not needed using your formula.

Thanks again
Maid Marion