Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have below formula
if(match(Date(MonthStart(today())-1,'MMM')='mar','apr')>0,1,2)
If previous month is mar or apr, i need to display as 1. But it always displays else part. ie 2.
Whats wromg in my code?
if(match(Date(MonthStart(today())-1,'MMM'),'Mar','Apr'),1,2)
if(match(Date(MonthStart(today())-1,'MMM'),'Mar','Apr'),1,2)