Results 1 to 7 of 7

Calculate fiscal year based on today's date

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    2010
    Posts
    5

    Calculate fiscal year based on today's date

    For the life of me, I can't figure out how to calculate the current fiscal year (e.g., 2021) based on today's date.

    For context, I have customers whose fiscal years begin in different months. Based on today's date (dynamically changes), I need to calculate their current fiscal year.

    For example, if their fiscal year begins in January, based on today's date (Aug. 26, 2021), they are in 2021. If their year begins in October, they are also in 2021 (as of today's date).

    If you look at the attached doc, my formula is flawed and doesn't reflect this. Please help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel formula to calculate year to date depreciation based on today's date
    By sunboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-07-2021, 05:35 PM
  2. Replies: 13
    Last Post: 10-29-2019, 07:55 AM
  3. [SOLVED] Delete Columns Macro, Based on Creating a Fiscal Year, Based on Today's Date
    By DemRulesDoe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2018, 11:02 AM
  4. how to convert date to fiscal year if fiscal year start at 16th or 17th of July
    By sushil shakya in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2013, 03:32 AM
  5. [SOLVED] Calculate Fiscal Year FY of a single date
    By Steve N. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-29-2012, 12:40 PM
  6. Replies: 2
    Last Post: 07-18-2012, 06:56 AM
  7. Calculate Fiscal Year From A Date
    By Determined in forum Excel General
    Replies: 7
    Last Post: 04-18-2007, 07:47 AM

Tags for this Thread

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