Remove Date Timestamp in Excel?

  • Thread starter Thread starter F.T.S.
  • Start date Start date
F

F.T.S.

Hi there,

I was wondering if someone can help me out. I am using a csv file and want
to calculate if things were done on time or not.

Example:

In the A column I would have "Date Expected"

In the B column I would have "Date Completed"

In the C column I have an IF formula such that if B<= A then "Meets"
otherwise "Not Met"

But I have a problem since I get the data from a csv file. The timestamp can
give the impression that something does not meet.

Example

Date Expected: 09/18/2006 1:00am
Date Completed: 09/18/2006 2:00am

As per the formula it would not meet due to being one hour late. But I want
to disavow the timestamps and only consider the actual day.

Is there a way to do this?

Thanks in advance.
 
This works for me.

=IF(DAY(B9)<=DAY(A9),"meets", "not met")


Gord Dibben MS Excel MVP
 
Back
Top