Latest Activity

Doug Leasure replied to Denise Austin's discussion Is there a formula out there that would add “For the Period Ending July 31, 2013” automatically when the period is set to 07?
"Hey Ralph.  Why don't we just expand the wording in the CHOOSE function?  How would this work if we make a simple modification? =CONCATENATE("For the ", CHOOSE(J3,"One month","Two months","Three…"
4 hours ago
Ralph replied to Denise Austin's discussion Is there a formula out there that would add “For the Period Ending July 31, 2013” automatically when the period is set to 07?
"Doug, I just noticed your reply.  Sorry for the six-month delay. Your code is definitely more efficient than my IF statement, and it works perfectly with one exception.  When the period is set to January, the text obviously still…"
9 hours ago
Beth Bowers replied to Denise Austin's discussion Is there a formula out there that would add “For the Period Ending July 31, 2013” automatically when the period is set to 07?
"Whoops, forgot to point out I have the fiscal year in A1 and Fiscal Period in A2 on the sheet  I am working on"
Friday
Beth Bowers replied to Denise Austin's discussion Is there a formula out there that would add “For the Period Ending July 31, 2013” automatically when the period is set to 07?
"Justin - Lots of fiscal years change the period end date each year, so a list is not practical.  But I did get it figured out without having to change the…"
Friday
 
 
 

© 2015   Created by Sage Alchemex.

Badges  |  Report an Issue  |  Terms of Service