Results 1 to 2 of 2

Thread: Monthly split from date range
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Monthly split from date range

    Hi, I'm trying to find the best formula for my spreadsheet that shows me the number of months within a fiscal year, with a start and end date range . Could someone help?


  2. #2
    New Member
    Join Date
    Feb 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Monthly split from date range

    01/10/2009 01/10/2010 01/10/2011 01/10/2012 01/10/2013 01/10/2014 01/10/2015 01/10/2016 01/10/2017 01/10/2018 01/10/2019 01/10/2020 01/10/2021
    Start End Prior FY 10 FY 11 FY 12 FY 13 FY 14 FY 15 FY 16 FY 17 FY 18 FY 19 FY 20 FY 21 FY 22
    01/01/2019 31/12/2020 0 0 0 0 0 0 0 0 0 9 3
    01/11/2018 30/04/2019 0 0 0 0 0 0 0 0 0 6 0
    01/10/2009 01/10/2010 01/10/2011 01/10/2012 01/10/2013 01/10/2014 01/10/2015 01/10/2016 01/10/2017 01/10/2018 01/10/2019 01/10/2020 01/10/2021
    Start End Prior FY 10 FY 11 FY 12 FY 13 FY 14 FY 15 FY 16 FY 17 FY 18 FY 19 FY 20 FY 21 FY 22
    01/01/2019 31/12/2020 0 0 0 0 0 0 0 0 0 9 3
    01/11/2018 30/04/2019 0 0 0 0 0 0 0 0 0 6 0

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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