LinkBack URL
About LinkBacks
I am trying to make a formula to convert calendar dates into the fiscal month names, my fiscal year starts on 7/4/15 and goes to 7/01/16. Rick
I am trying to make a formula to convert calendar dates into the fiscal month names, my fiscal year starts on 7/4/15 and goes to 7/01/16. Rick
What would some sample data and answers look like? Not sure I understand what you need here
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I am just trying to covert a calendar date into a fiscal month name with fiscal year 7/4/15 to 7/01/16. Example 08/07/15 would convert the date to JUL, 08/08/15 would covert to Aug.
Still not understanding what you want
I can't MMM for example "the fiscal month of September runs from 9/05/15 to 10/02/15" so I need 10/02/15 to still call out Sep.
I never have to work with fiscal/financial years/months but it seems like everyone has their own version!
So, to the casual observer this is rather confusing to have a date period start/end on a date other than the 1st or last day of the month.
I suggest creating a table and using a lookup function.
Last edited by Tony Valko; 10-03-2015 at 06:34 PM.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
If you can give us the dates and the corresponding month names I'll show you what that formula would look like.Originally Posted by Tony Valko
That is kinda why I asked for some sample data and expected answers
why formula?? how about just formatting
right click & select format cells
custom
type mmm and enter
for example: 10/15/2015 = Oct
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks