Hi, I was usingwith some other formulas to open a pdf file within various folders based on year and month, =2015 is the year and =4 is the month.
Please Login or Register to view this content.
I now have too many years, excel error says no more than 64 levels. I currently need to go up to 2021 March.
I am looking for suggestions for how I may be able to accomplish this please!
Many thanks
I'm sure there is a way to construct this string without the IF/AND, but you need to explain how you are getting the file names. How you get "2015-16" from April 2015, and why are April and May both "2015-16"?
P.S. Nice user name!
=IF(AND(H21=2015,I21=4),"2015-16",IF(AND(H21=2015,I21=5),"2015-16"))
What does the "16" in "2015-16" represent and should the second instance also be "2015-16" ??
Please see attached file, I hope it makes it a little clearer.
This formula will compose the folder name based on C5 and D5. It will work for any year.
Formula:
Please Login or Register to view this content.
P.S. Future reference: It would have helped immensely to mention in your first post that 2015-16 means a fiscal year from April 2015 to March 2016.
6StringJazzer. Thank you very much for the code, perfect thanks. Apologies for the initial lack of detail.
Glad to help! And I will think of you every time I pick up a tuning fork.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks