Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have following List box with Fiscal Years
FYear
2011/2012
2012/2013
2013/2014
and Fmonth list box contain the following
SEP
OCT
NOV
.....
.....
AUG
I have created two list box where I want the text to appear as follows depending on my selection
Text Box 1 Text Box 2
Sep-2011 to Aug-2012 Sep-2012 to Aug-2013 (if I select 2012/2013 as FYear)
Pls help me to write the expression
Quick and dirty:
='Sep-'&LEFT('2011/2012',4)&' to Aug-'&RIGHT('2011/2012',4)
Replace '2011/2012' with e.g. ONLY(FYear).
And of course a LEFT(ONLY(FYear),4)-1 for previous year.
The "problem" is that any selection in Fmonth will NOT impact the text box, but I am not sure if you actually need that.
Kind regards
Niklas
Will you please help me solve my issue
Quick and dirty:
='Sep-'&LEFT('2011/2012',4)&' to Aug-'&RIGHT('2011/2012',4)
Replace '2011/2012' with e.g. ONLY(FYear).
And of course a LEFT(ONLY(FYear),4)-1 for previous year.
The "problem" is that any selection in Fmonth will NOT impact the text box, but I am not sure if you actually need that.
Kind regards
Niklas
In addition to that:
='Sep-'&LEFT('2011/2012',4)&' to '&Fmonth&'-'&RIGHT('2011/2012',4)
Thanks Both of You