Nested If's for Date Range

[ExcelPoor]

Hi, can someone please help me combine this formula. I'm no good at nested IF functions.
I currently have two columns as below and hence have to create two pivot tables. I'm hoping to combine them into one column, so the pivot data captures both of these scenarios.
=IF(K2 < TODAY()-300,"Yes","No")
=IF(K2 < TODAY()-365,"Yes","No")

Basically, what I need is if the date is greater than 10 months, return '10 months', and if the date is greater than 12 months, return '12 months'.
Thank you

 

[kvsrinivasamurthy]

Tyr.

=IF(K2="","",IF(K2<EDATE(TODAY(),-12),"12 Months",IF(K2<EDATE(TODAY(),-10),"10 Months","")))

 

[Scott Huish]

If your date in K2 is 12/9/24 should that return 12 or 10?

If 12, perhaps:
=TEXT(XLOOKUP(DATEDIF(K2,TODAY(),"m"),{12,10,0},{12,10,0},,-1),"0 ""months"";;")