+ Reply to Thread
Results 1 to 2 of 2

Comparing dates 4 days older or more

  1. #1
    Registered User
    Join Date
    08-19-2012
    Location
    Portland Oregon
    MS-Off Ver
    Excel 2007
    Posts
    11

    Comparing dates 4 days older or more

    Hi everyone
    I’m trying to find a way to compare dates on two columns and return an answer if one is 4 days or more older.

    If the date Column A is 4 days or older than the date on Column B, return a “Yes” on Column C. If not return a “No”.

    Thank you in advance.
    DH
    Attached Files Attached Files

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Comparing dates 4 days older or more

    In C4, put the following formula, then fill down to the other rows:

    =IF(B4-A4>=4,"yes","no")

    - Moo

+ 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