IF function finding a date in a date range

[KelleyScott]

Hello,
Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula....

I have a column with different dates in each cell (B25:B34). I also have some random dates listed in other cells (eg, N30). I would like a formula in cell N31 that will search the date range (B25:B34) for the exact date in cell N30 and if the date appears, then return the result of text "school" (or cell "A3" as the word "school" appears in that cell). If the exact date doesn't appear in the range (B25:B34) then leave the cell empty.

I thought it would be =IF(AND(N30<="$B$25:$B$34",N30>="$B$25:$B$34"),$A$3,"")

but this isn't working.

thank you

[windy58]

As long as there are no repeated dates in column B then try this in N31

=IF(COUNTIF(B25:B34,N30)=1,A3,"")

Windy

[samba_ravi]

=if(countif(b25:b34,n30),a3,"")