Query

[sree_31]

I want to write an array formula which will compare two dates.
Eg : I have a range of dates in cells A3:F3
i want to see whether the month and year entered by the user exists in cell A3:F3
This message was edited by sree_31 on 2002-04-24 07:52

 

[Aladin Akyurek]

On 2002-04-19 01:05, sree_31 wrote:
I want to write an array formula which will compare two dates.
Eg : I have a range of dates in cells A3:F3
i want to see whether the month and date entered by the user exists in cell A3:F3

Lets say that A1 houses the date entry by the user in true date format:

=COUNTIF(A3:F3,A1)>0

will return TRUE if the entry exists in the target range, otherwise FALSE.