Expression calculation for last 12 months not including this month

[matthewp]

I'm trying to create an expression calculation for last 12 months not including this month.

So for February it would be 2016 FEB to 2017 JAN

I tried

=Count({1<MMMYY ={'>=$(=Date(AddMonths(Today(), -13),'MMM-YY'))<=$(=Date(Today(), 'MMM-YY'))'}>} DISTINCT [MYID])/12

But it didn't work.

[sunny_talwar]

Is the format MMM-YY or MMMYY?

[matthewp]

YYYYMM

[sunny_talwar]

Then give this a try

=Count({1<MMMYY ={'>=$(=Date(AddMonths(Today(), -13),'YYYYMM'))<$(=Date(MonthStart(Today()), 'YYYYMM'))'}>} DISTINCT [MYID])/12

Note: I added MonthStart to upper condition and changed from <= to <

[matthewp]

hmm that gives me 0

[sunny_talwar]

Is there a space between YYYY MM or is it YYYYMM? If there is space, may be this

=Count({1<MMMYY ={'>=$(=Date(AddMonths(Today(), -13),'YYYY MM'))<$(=Date(MonthStart(Today()), 'YYYY MM'))'}>} DISTINCT [MYID])/12

[matthewp]

Still 0,

no space between the dates.

If this helps, i have a trigger on the same sheet that uses

=  '>=' & date(AddMonths(MonthStart(Today()),-12), 'YYYYMM')   & '<=' & date(AddMonths(MonthStart(Today()),-0), 'YYYYMM')

[Anil_Babu_Samineni]

Why do you need 0 for second Equation, May be this?

=  '>=' & date(AddMonths(MonthStart(Today()),-12), 'YYYYMM')   & '<=' & date(MonthStart(Today()), 'YYYYMM')

[sdmech81]

try this:

=Count({1<num(MMMYY) ={'>=$(num=Date(AddMonths(Today(), -13),'YYYY MM')))<$(=Date(MonthStart(Today()), 'YYYY MM'))'}>} DISTINCT [MYID])/12

Wts tht MMMYY??

[sdmech81]

Plss attach application..