Results 1 to 2 of 2

Thread: Calculate Fiscal Year Date
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2012
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Calculate Fiscal Year Date

    I have a cell a1 with date say "07/31/2016", I need to populate cell b2 with a date that can calculate fiscal year, when the fiscal year is not same as calendar year.
    The fiscal year runs from 08/1/20xx to 07/31/20xx+1,
    For example:
    for date 07/15/2016 the fiscal year should end on 07/31/2016
    for date 08/1/2015 the fiscal year end date should be 07/31/2016
    for date 05/12/2015 the fiscal year should end on 07/31/2015
    for date 08/15/2015 the fiscal year should end on 07/31/2016.

    What formula can I use when the date in cell a1 can be different for each cell?

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,717
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Calculate Fiscal Year Date

    For a date in cell A1, the formula would look like:
    Code:
    =DATE(IF(MONTH(A1)>7,YEAR(A1)+1,YEAR(A1)),7,31)
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

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
  •