One way:

=IF(WEEKDAY(B8)=5,2,0)

HTH,
Paul


--

"Sean" wrote in message
ups.com...
How do I say the following

=IF(B8=Thursday,2,0) i.e. Return the value 2 if B8 returns
"Thursday"

Where B8 is a date but it is formatted to show the day


Thanks