I have 2 cells containing datetime values. I need to compare just the
date portion of the cells. eg: (If( Date(Cell1) <= Date(Cell2),1,0)

By what means can I get there as the example doesn't work.

Thanks in advance for any help you can provide!

Rita Brasher
Project Engineer
FedEx Express / Int'l MIS and Training

Just look at the integer portion of the cells:

if int(cell1.value) = int(cell2.value) then



Rita Brasher wrote:
>
> I have 2 cells containing datetime values. I need to compare just the
> date portion of the cells. eg: (If( Date(Cell1) <= Date(Cell2),1,0)
>
> By what means can I get there as the example doesn't work.
>
> Thanks in advance for any help you can provide!
>
> Rita Brasher
> Project Engineer
> FedEx Express / Int'l MIS and Training

--

Dave Peterson