IF statement date stamp

[Benny3]

Hello

Im trying to create an IF statement to look at a date stamp that was converted to a numeric value.

Its a value for "spring break" actually, but if the date stamp column B6 is between the value 41363 and 41370 return a 1 else a 0.

Any help to get the operators to work for this range would be super helpful! Thanks!

=IF(B6=41363<>41370,1,0)

[Jonmo1]

Try

=IF(AND(B6>=41363,B6<=41370),1,0)

[Phuocam]

Or try:

(B6>=41363)*(B6<=41370)