Formula to Display Federal Fiscal Year - Quarter Based on Dates Entered in Another Column
Hi there,
What's the best formula to display Federal Fiscal Year - Q# based on dates entered in this format (xx/xx/xx) in another column? (Not sure how to best handle this since the Federal Fiscal Year for 2015 started on 10/1/2014)
I can't set-up a lookup table in another sheet so am hoping there's a way to do this without doing that.
Thanks
if you cant use a lookup table - can just use a hardcoded IF formula
IF( AND ( Datecell >= 10/1/2014 , datecell < 1/1/2015 ) , "FY15-Q1", IF( AND ( dates for Q2), etc
OR you could do a lookup formula with an array
=LOOKUP(A2,{41913,42005},{"FY15-Q1","FY15-Q2"})
I have had to use the date as a general number - sure you can do it as a date though
Last edited by etaf; 04-20-2015 at 12:18 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks