Remove Date Timestamp in Excel?

[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.

 

[Gord Dibben]

This works for me.

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


Gord Dibben MS Excel MVP

 

[F.T.S.]

Thanks! I will try it out!

This works for me.

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


Gord Dibben MS Excel MVP