extract weekend out of dates

[legolas]

hello all,

i am trying to extract into B only saturday and sunday from A
my both formulas suddenly are not working i wonder what is wrong with the file

I appreciate any help

[zbor]

Working for me when I opened file...

[legolas]

mine is showing Sunday along B and C, however i tried same file on two computers already
can it be some settings in my pc date

[zbor]

Check in Excel options -> Formulas is Calculation set to Automatic or Manual.
Should be Automatic

[legolas]

i have it set to automatic but is not working

[legolas]

ok fixed
went to menu/resources/diagnose/run diagnose

found some errors and was fixed again

thanks for your help