| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date comparison between 2 datetime fields
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date comparison between 2 datetime fields
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Based on Comparison with Two Fields | Excel Discussion (Misc queries) | |||
| hi I want to add the results on comparison with 2 fields. | Excel Programming | |||
| Using datetime fields as parameters in a query... | Excel Programming | |||
| Date or datetime | Excel Programming | |||
![Rita Brasher[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
