Results 1 to 5 of 5

Check for date range within date range

Threaded View

  1. #1
    Registered User
    Join Date
    05-19-2023
    Location
    Belgium
    MS-Off Ver
    365
    Posts
    7

    Question Check for date range within date range

    *updated, new attachment lower in post*

    Hello all

    I'm stuck with a logic that I can't figure out how to calculate with excel formulas.
    I need to calculate the amount of full months a project occurs in the last, current and next financial year. I use DD/MM/YY date format.

    Last financial year runs from 01/04/2022 until 31/03/2023
    Current financial year runs from 01/04/2023 until 31/03/2024
    Next financial year runs from 01/04/2024 until 31/03/2025

    The solution need to be dynamic in such way that you can alter the dates of the last, current and next financial year, so the calculations will adapt to the new input. This file is to be used for several years.

    I hope that the explanation above is sufficient to understand my question.
    Anyone who knows which formula's to use to calculate the amount of months per financial year (date range)?

    Thanx in advance.

    Worksimplify
    Last edited by Worksimplify; 05-22-2023 at 05:33 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Check in a specific column/range if a cell has a date value (or better) a date property
    By NewBee_HS in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-15-2022, 05:24 AM
  2. [SOLVED] VBA Code to check if entry exists in a range for each date in a date range
    By tariqfaiyaz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2022, 09:17 PM
  3. [SOLVED] Check if a date is within +X months of any date within a cell range
    By value3 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-07-2021, 03:58 AM
  4. Replies: 3
    Last Post: 10-31-2018, 01:12 PM
  5. Replies: 7
    Last Post: 07-14-2017, 12:04 PM
  6. Check a date range and return value based on the date range
    By KeithCar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-13-2015, 12:55 PM
  7. [SOLVED] If statement to check if date falls between date range
    By mcranda in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-21-2013, 07:31 PM

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