Date comparison between 2 datetime fields

R

Rita Brasher

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
 
D

Dave Peterson

Just look at the integer portion of the cells:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Minimum excluding blank cells 9
Convert Text to Date 4
2-Axis Column Graphs 4
Bring focus to same cell every time opened?? 2
Append Query, New Column help 1
Trendline Issues 4
Error upon exporting results of query to text file 1
Computed Column from Date Field 1

Top