+ Reply to Thread
Results 1 to 4 of 4

If date is between two dates copy row to another sheet.

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    Australia
    MS-Off Ver
    Excel 2012
    Posts
    10

    Question If date is between two dates copy row to another sheet.

    Hi. I need a formula that will check if any values in column "C" on the "Payments" sheet are within the two dates specified by the variables "sDate" which is the start date and "sEnddate' which is the end date. The dates will only be month to month, so if sDate = 01/02/2012 then sEnddate would be = 29/02/2012.

    Dates in the "C" column of the "Payments" sheet are stored as full dates, eg. 13/02/2012.

    If any of those dates are between the ones specified they the entire row that they're on needs to be copied to the "Compare" sheet, with data being inputted on that sheet starting at Row 2.

    Thanks in advance.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,162

    Re: If date is between two dates copy row to another sheet.

    Possibly...
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-18-2012
    Location
    Australia
    MS-Off Ver
    Excel 2012
    Posts
    10

    Re: If date is between two dates copy row to another sheet.

    Quote Originally Posted by dangelor View Post
    Possibly...
    Please Login or Register  to view this content.
    I get a
    Screen Shot 2012-05-21 at 11.36.43 AM.png

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,162

    Re: If date is between two dates copy row to another sheet.

    Try this (added a missing period)...
    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)

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