+ Reply to Thread
Results 1 to 3 of 3

How to get second FY that's April 2015 March 2016?

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    How to get second FY that's April 2015 March 2016?

    Hi friends,
    I want to get the second previous financial year. With this formula I get the previous fy. How to amend it to get second previous fy?
    For April 2016
    Please Login or Register  to view this content.
    For March 2017
    Please Login or Register  to view this content.
    Now I require for the second previous fy April 2015 March 2016

    Any help will be highly appreciated.

    Thanking you,
    Sincerely,

    mso3

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: How to get second FY that's April 2015 March 2016?

    start of FY

    =VLOOKUP(TEXT(IF(MONTH(TODAY())>=4,DATE(YEAR(TODAY())-2,4,1),DATE(YEAR(TODAY())-3,4,1)),"mmmm"),$CA$2:$CB$13,2,FALSE)&" "&TEXT(IF(MONTH(TODAY())>=4,DATE(YEAR(TODAY())-2,4,1),DATE(YEAR(TODAY())-3,4,1)),"[$-4000000]yyyy")

    End of FY

    =VLOOKUP(TEXT(IF(MONTH(TODAY())>=4,DATE(YEAR(TODAY())-1,4,-1),DATE(YEAR(TODAY())-2,4,-1)),"mmmm"),$CA$2:$CB$13,2,FALSE)&" "&TEXT(IF(MONTH(TODAY())>=4,DATE(YEAR(TODAY())-1,4,-1),DATE(YEAR(TODAY())-2,4,-1)),"[$-4000000]yyyy")

    I am not convinced that it was necessary to close the previous thread!!
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 04-11-2017 at 05:54 AM.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: How to get second FY that's April 2015 March 2016?

    Hi Glenn,

    It's working fine.

    I appreciate you for the same.

    Thank you and have a nice day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 23
    Last Post: 01-03-2022, 10:45 AM
  2. Replies: 3
    Last Post: 03-22-2016, 04:03 AM
  3. [SOLVED] Sumifs against financial year 2015-2016
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-28-2016, 11:41 AM
  4. Mildly complicated embedded formula pulling data for 2015 but not 2016
    By Jason.F in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-22-2016, 11:30 AM
  5. Replies: 0
    Last Post: 05-27-2015, 12:11 PM
  6. Replies: 1
    Last Post: 05-17-2013, 05:53 AM
  7. Replies: 7
    Last Post: 05-09-2013, 05:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1