Isolating dates in a range

[richardthelionheart]

I have this list of dates in column A. In column B I want to return 1 if in the second half of the year and 0 if any date was before 1 July 2017 including all of 2016, 2015, 2014 etc All help greatly appreciated.

2/10/2017

25/09/17

18/09/17

24/07/17

15/07/17

5/7/2017

28/06/17

24/06/17

10/6/2017

31/05/17

17/05/17

8/4/2017

1/4/2017

4/2/2017

28/01/17

<tbody>
</tbody>

 

[pkdeimos]

B1 = IF(MONTH(A1)<7,0,1)

Hope this helps.

 

[richardthelionheart]

B1 = IF(MONTH(A1)<7,0,1)

Hope this helps.

Thanks for your reply.
Yes, that would have worked except now I have discovered after applying the equation that what I see in the list is not what's behind the list. They have used varying date, text formats and it's just a mish mash of formats which appear to be uniform but are not. Will need to try to find a way.