Formulas just not working?

[Jschueller]

Hi and thanks for reading.

I'm sure this is just some sort of mistake I'm making, but I have a sheet set up as shown below. Just trying to get column B's value to
to show up in the corresponding cell in columns E:K if the formula evaluates appropriately. This worked out fine in column E, but the formulas in F just don't seem to be evaluating at all. Did I copy the array over incorrectly or something? This is driving me nuts.

Thanks!

 

[Andrew Poulsom]

What does the Evaluate Formula tool tell you about the values in the referenced cells? Are they all serial dates?

 

[Jschueller]

What does the Evaluate Formula tool tell you about the values in the referenced cells? Are they all serial dates?

Sheesh, that was it. Boy do I feel dumb. Only cells a1 and a2 were evaluating as serial dates. Making the change to the rest of column a solved the issue. Thanks!