How to create a column showing last 12 months - table with month numbers only, not dates

[Anonymous]

Hi,

I have a table that shows number of worked hours for the company as a total. The numbers are updated manually every month for the previous month (e.g. now in october, the numbers for september were filled in to the excel sheet).

I want to create a column that shows "1" if the month is within the last 12 months from todays month, and "0" if not (see illustration below).

I have created YearMonth and MonthIndex columns to help me with this, but I am not able to complete the formula to create the "last 12 months" column. Can anyone help me out?

[amitchandak · Accepted solution]

@Anonymous 

Try a new column like

new column =
var _date = today()
var _max = format(today(), "YYYYMM")
var _min = format(date(year(_date), month(_date)-12,day(_date)), "YYYYMM")
return
if([yearmonth]>=_min && [yearmonth] <= _max ,1,0)

[Anonymous]

Thanks @amitchandak, just what i needed!