TheNewGuy22
New Member
- Joined
- Mar 19, 2014
- Messages
- 38
Hello Everybody again,
I'm having difficulty figuring out how to set up an if statement without putting 12 ifs within each other.
I'm trying to get a formula that recognizes what month it is and then displays either FYyy or yyyy based on the month it shows and the date.
This is what I have. I want a way to get the bolded result based on the columns already there.
<tbody>
</tbody>
Is there a way to list off say:
{Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec} and then have an equivalent array with the possible outcomes?
Thank you very much,
Robin
I'm having difficulty figuring out how to set up an if statement without putting 12 ifs within each other.
I'm trying to get a formula that recognizes what month it is and then displays either FYyy or yyyy based on the month it shows and the date.
This is what I have. I want a way to get the bolded result based on the columns already there.
Nov | FY09 | 11/5/2008 | 12/5/2008 | 2008 |
Dec | FY09 | 12/6/2008 | 1/6/2009 | 2008 |
Jan | FY09 | 1/7/2009 | 2/4/2009 | 2009 |
Feb | FY09 | 2/5/2009 | 3/5/2009 | 2009 |
Mar | FY09 | 3/6/2009 | 4/3/2009 | 2009 |
Apr | FY09 | 4/4/2009 | 5/5/2009 | FY09 |
May | FY09 | 5/6/2009 | 6/3/2009 | FY09 |
Jun | FY09 | 6/4/2009 | 7/6/2009 | FY09 |
Jul | FY10 | 7/7/2009 | 8/5/2009 | FY10 |
Aug | FY10 | 8/6/2009 | 9/3/2009 | FY10 |
Sep | FY10 | 9/4/2009 | 10/5/2009 | FY10 |
Oct | FY10 | 10/6/2009 | 11/3/2009 | 2009 |
<tbody>
</tbody>
Is there a way to list off say:
{Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec} and then have an equivalent array with the possible outcomes?
Thank you very much,
Robin