Excel 2000 - Need assistance with DATE/TIME 2

[ladyck3]

If the spreadsheet shows the following information:
Col A - Due Date Col B - Finish Date
10/23/2003 10/23/03 1:43:23pm

In C the following formula is used:
=IF((B3>A3),"late","on time&quot

The result should come back ON TIME because it has been completed on the same date and is NOT late. However, the first column, without times listed, assumes it is Midnight, so anything after midnight is considered late.

What formula can I use to have it disregard the times and concerntrate on the DATE ONLY. We can do a text to column and split the date/time in Column B but that is now how we need the data to be.

Any help would be greatly appreciated.....

Thanks in advance.
LadyCk3

 

[combo]

Just add 1 in your formula:
=IF((B3>A3+1),"late","on time&quot

combo

 

[Wray69]

give this a try;

=IF((ROUND(B2,0)>A2),"late","on time&quot

Regards,

Wray

 

[IfThenElvis]

Hi, try this:
=IF(rounddown(B3,0)>A3),"late","on time&quot
Excel days are saved as whole numbers and hours/minutes as fractions. Today May 30 is 37771 and 12 noon would be 37771.5 So you can rounddown the delivery time to remove the time of day.

 

[ladyck3]

Wray, IfThenElvis, thanks so much... Wray the ROUND function did it, but because the ROUNDDOWN was so close, well IfThenElvis, thought I'd give you a star too!!!

Thanks folks!

Combo, its not the function we are using but I do appreciate you helping as well ... the ROUND thing really rocks...

Thanks again!!!!