Results 1 to 6 of 6

Compare dates

Threaded View

  1. #1
    Registered User
    Join Date
    12-20-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    21

    Compare dates

    Hi All,

    Could you please help,,, I need a macro or a formula to check the deffirence between dates and give a reuslt in column c
    column A column B Today() Column C results
    11/09/2014 02/10/2014 < 1 month
    05/08/2014 02/10/2014 1 -3 month
    02/06/2014 02/10/2014 4-6 month
    30/03/2014 02/10/2014 7-12 month
    30/05/2013 02/10/2014 > 1 Year


    Thanx and 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. [SOLVED] Best Way to Compare Dates
    By alcharbonneau in forum Excel General
    Replies: 3
    Last Post: 06-05-2012, 01:01 PM
  2. Compare two dates
    By MichaelM in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-24-2010, 01:26 PM
  3. How to compare dates
    By poojabans in forum Excel General
    Replies: 6
    Last Post: 05-18-2009, 12:05 PM
  4. Compare dates to ranges of dates
    By Santed593 in forum ExcelTip.com Feedback / Comments / Suggestions
    Replies: 1
    Last Post: 08-05-2005, 12:22 PM
  5. How can i compare dates?
    By aijihz in forum Excel General
    Replies: 4
    Last Post: 03-27-2005, 09:50 PM

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