Solved Need help comparing dates in Excel.

Microsoft Excel 010 - complete package
March 16, 2012 at 10:05:33
Specs: Windows 7
I have two columns of dates - a Due Date and a Completed Date - I want to compare the dates in each column and have the results appear in a table I have created on a separate sheet in the same workbook. If the completed date is after the due date for a certain type of information (contained in another column; ie, IMAC or Out of Scope), I want to count that instance as "Missed" in my table. Any help would be greatly appreciated!

See More: Need help comparing dates in Excel.

Report •


#1
March 16, 2012 at 11:12:55
✔ Best Answer
I don't quite understand how the "IMAC or Out of Scope" information relates to your question.

If all you are trying to do is compare 2 values (dates) a simple IF function should do it for you:

=IF(A1>B1, "Missed", "")

This will return Missed when A1 is greater than B1 and return a blank cell if not.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 16, 2012 at 11:49:22
My spreadsheet looks kinda like this:

TYPE DUE DATE DATE COMPLETED
IMAC 3/2/2012 3/1/2012
IMAC 3/5/2012 3/9/2012
OUT OF SCOPE 3/12/2012 3/10/2012


The table that contains the totals of all of this info looks kinda like this:

TYPE TOTAL COMPLETED MISSED SLA
IMAC 14 10 ?
OUT OF SCOPE 8 8 ?



Report •

#3
March 16, 2012 at 14:13:57
I still don't know what you are looking for.

First, before posting any more example data in this forum, please click on the blue line at the end of this post and read the instructions on how to post data so that it lines up and is easier for us to read.

As to your question, I see multiple entries of e.g. IMAC with dates in your "spreadsheet" but only one entry of IMAC in your "table".

What is it that you want the "table" to look like when you are done?

(BTW I'm also not sure why you differentiate between a "spreadsheet" and a "table". I assume that all of this data is in an Excel worksheet.)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question