+ Reply to Thread
Results 1 to 13 of 13

How to determine how many fiscal years are present from start date to end date.

Hybrid View

terrivega3500 How to determine how many... 08-06-2012, 02:34 PM
Richard Buttrey Re: How to determine how many... 08-06-2012, 02:56 PM
terrivega3500 Re: How to determine how many... 08-06-2012, 04:15 PM
jason.b75 Re: How to determine how many... 08-06-2012, 04:20 PM
terrivega3500 Re: How to determine how many... 08-06-2012, 04:40 PM
jason.b75 Re: How to determine how many... 08-06-2012, 05:03 PM
Ace_XL Re: How to determine how many... 08-06-2012, 05:04 PM
jason.b75 Re: How to determine how many... 08-06-2012, 05:21 PM
terrivega3500 Re: How to determine how many... 08-07-2012, 10:51 AM
daddylonglegs Re: How to determine how many... 08-06-2012, 05:33 PM
jason.b75 Re: How to determine how many... 08-07-2012, 11:02 AM
terrivega3500 Re: How to determine how many... 08-07-2012, 11:36 AM
Cutter Re: How to determine how many... 08-07-2012, 01:25 PM
  1. 08-06-2012, 04:20 PM #1
    jason.b75
    jason.b75 is offline
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: How to determine how many fiscal years are present from start date to end date.

    With start date in A2 and end date in B2

    Formula: copy to clipboard 
    =YEAR(EOMONTH(B2,5))-YEAR(EOMONTH(A2,-7))
    Reply With QuoteRegister To Reply
  2. 08-06-2012, 04:40 PM #2
    terrivega3500
    terrivega3500 is offline
    Registered User
    Join Date
    08-05-2012
    Location
    cHICAGO
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to determine how many fiscal years are present from start date to end date.

    Would it be possible to take it one step further and have the result bring back the years instead of the instances?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1