Remove Date Timestamp in Excel? "F.T.S." <fstrass[ at ]netcom.ca> 21.09.2006 19:06:27 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.

Re: Remove Date Timestamp in Excel? Gord Dibben <gorddibbATshawDOTca> 21.09.2006 19:26:53 This works for me. =IF(DAY(B9)<=DAY(A9),"meets", "not met") Gord Dibben MS Excel MVP On Thu, 21 Sep 2006 15:06:27 -0400, "F.T.S." <fstrass[ at ]netcom.ca> wrote: [Quoted Text] >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. > >

Re: Remove Date Timestamp in Excel? "F.T.S." <fstrass[ at ]netcom.ca> 21.09.2006 20:35:44 Thanks! I will try it out! "Gord Dibben" <gorddibbATshawDOTca> wrote in message news:gnp5h2l6fj3jtu8gn2nlfmr29p5c95dkmu[ at ]4ax.com... [Quoted Text] > This works for me. > > =IF(DAY(B9)<=DAY(A9),"meets", "not met") > > > Gord Dibben MS Excel MVP > > > On Thu, 21 Sep 2006 15:06:27 -0400, "F.T.S." <fstrass[ at ]netcom.ca> wrote: > > >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. > > > > >