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
    Post Thanks / Like
    0 Post(s)
    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
    Post Thanks / Like
    57 Post(s)
    11 Thread(s)

    Default Re: Calculate Fiscal Year Date

    For a date in cell A1, the formula would look like:
    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