+ Reply to Thread
Results 1 to 3 of 3

Return Specific Date When it Falls Within a Date Range

  1. #1
    Registered User
    Join Date
    08-07-2020
    Location
    Spokane Valley, WA
    MS-Off Ver
    Office 365
    Posts
    1

    Cool Return Specific Date When it Falls Within a Date Range

    Greetings,

    I would like to get some ideas on how to return a date in a new cell based on the following criteria:

    Cell A1: The Date I am referencing (i.e. 07/01/2019)
    Cell A2:
    If the date is between Jan 01 and March 31, return 03/31/YYYY where YYYY is the year in cell A1
    If the date is between April 01 and December 31, return 12/31/YYYY where YYYY is the year in cell A1


    So if the date is 07/01/2019 in cell A1, then A2 would reflect 12/31/2019 because the range is between April 01 and December 31.

    Thanks in advance for your help with this.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Return Specific Date When it Falls Within a Date Range

    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Forum Contributor Dante Amor's Avatar
    Join Date
    07-24-2020
    Location
    MEXICO
    MS-Off Ver
    Excel 2013
    Posts
    212

    Re: Return Specific Date When it Falls Within a Date Range

    Try:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If a Date falls within a Date Range, add up specific cells, etc
    By woodcycl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-14-2019, 03:38 PM
  2. Return Value if date falls within range
    By Kcroft9 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-01-2019, 07:43 AM
  3. Replies: 4
    Last Post: 03-21-2018, 09:25 AM
  4. check in which range a date falls and return a specific value
    By beltzer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2016, 04:29 PM
  5. [SOLVED] Formula to assign specific numbers if a date falls within a certain date range
    By headley4ever in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2014, 04:16 PM
  6. Search date range +/- 7 days and return date that falls within range
    By tlafferty in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2013, 03:26 PM
  7. Replies: 15
    Last Post: 04-08-2013, 12:40 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