Counting a certain percentage reached as 1 for attendance

Hi all,

 

I am trying to work on a database used for attendance calculations, essentially to avoid any double counting in data collection. If a person attends 3 days out of 5 then this should equal =1 

 

it should be a basic code, but i keep making an error with what i have tried so far. 

 

As an example of the table below - 3 days attended, i would then need the final column to work that out as either 1 or 0 depending on whether it hit the threshold of 3 or above.

 

Mond	Tues	Wed	Thurs	Fri	Days attended	= 1 attendee
x		x	x		3

 

thanks for your time

 

Kind Regards,

tom