|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 29th, 2009, 03:47 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
date comparison
hi community
how can i write a comparison between two dates in the cells, I am using the Advance Filter, and wanting to filter a set of records, when i enter in a cell, =14 Mar 2009, the data changes to a text format? i wanted to use 2 dates that are between the dates oof March 14 and March 22 thanks community for the kind assistance.  -- oldLearner57 
|
|
#2
March 29th, 2009, 04:06 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
date comparison
The first criterion would be like
="=" & DATE(2009,3,14) It's a string, but with the date converted (via the Date function) to a numeric value. The date could also be in another cell, so your criterion would be like ="=" & I3 "oldLearner57" wrote: hi community how can i write a comparison between two dates in the cells, I am using the Advance Filter, and wanting to filter a set of records, when i enter in a cell, =14 Mar 2009, the data changes to a text format? i wanted to use 2 dates that are between the dates oof March 14 and March 22 thanks community for the kind assistance. -- oldLearner57
|
|
#3
March 29th, 2009, 04:45 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
date comparison
10s bapeltzer, it works perfectly well and solved my task!! appreciated your
guidance. 10s again to You and Community. -- oldLearner57 "bapeltzer" wrote: The first criterion would be like ="=" & DATE(2009,3,14) It's a string, but with the date converted (via the Date function) to a numeric value. The date could also be in another cell, so your criterion would be like ="=" & I3 "oldLearner57" wrote: hi community how can i write a comparison between two dates in the cells, I am using the Advance Filter, and wanting to filter a set of records, when i enter in a cell, =14 Mar 2009, the data changes to a text format? i wanted to use 2 dates that are between the dates oof March 14 and March 22 thanks community for the kind assistance. -- oldLearner57
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
