You were referencing column C for the last parameter. It should be B like below. This will remove the #NUM error
The #VALUE error is a bit odd but re-entering the date in column B corrects this. It must be the date format used or like you suggest due to the machine it was creatde on.