Results 1 to 6 of 6

Return value, If a date falls between two dates - Need VBA code support

Threaded View

bala04msw Return value, If a date falls... 01-05-2021, 01:37 AM
Sintek Re: Return value, If a date... 01-05-2021, 03:06 AM
bala04msw Re: Return value, If a date... 01-05-2021, 05:32 AM
Sintek Re: Return value, If a date... 01-05-2021, 05:34 AM
bala04msw Re: Return value, If a date... 01-05-2021, 06:11 AM
Sintek Re: Return value, If a date... 01-05-2021, 06:15 AM
  1. #1
    Forum Contributor
    Join Date
    08-19-2016
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    300

    Return value, If a date falls between two dates - Need VBA code support

    Dear forum experts,

    I am coming with a need of VBA code for if statement. I have a date in Column A and kept field for Start date (01-04-2020) and End date (30-10-2020). If Column A date falls between the mentioned date in Start and End date field, result to be returned as "Yes" in Column B orelse "No".

    The model excel data set has been attached for your kind reference and kindly do the needful.

    Regards
    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. If date falls between two dates then return true
    By Anarchus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-31-2017, 02:05 AM
  2. [SOLVED] VLOOKUP to Return Value if date falls between two dates
    By Cdubisms in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-23-2016, 12:38 PM
  3. VLOOKUP to return value if date falls between two dates
    By Cdubisms in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2016, 11:49 AM
  4. VLOOKUP to return value if date falls between two dates
    By Cdubisms in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-23-2016, 11:48 AM
  5. HELP: Return a value with a date that falls between two other dates
    By hionman in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-18-2014, 08:01 AM
  6. [SOLVED] Looking for formula to return a date that falls between 2 dates
    By cobo1981 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-13-2014, 01:12 PM
  7. [SOLVED] Return value in X if date in Y falls between two dates - Help!
    By nephilim3uk in forum Excel General
    Replies: 4
    Last Post: 07-08-2012, 10:13 AM

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