LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Based on Comparison with Two Fields Mashuganah Excel Discussion (Misc queries) 2 December 14th 09 08:14 PM
hi I want to add the results on comparison with 2 fields. navpoo Excel Programming 2 July 10th 04 12:09 AM
Using datetime fields as parameters in a query... Olaf Stetzer Excel Programming 1 January 7th 04 02:55 PM
Date or datetime Dkso Excel Programming 1 December 2nd 03 08:25 PM


All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"