Hey guys,

I was wondering what the best formula would be to have a cell populate with the day of the week based on another cell having the date.

Example:

A2 = March 27, 2014
B2 = Thursday

I am currently using this formula:

=CHOOSE(WEEKDAY(B19),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

The problem I have is that if there is no date in the cell it will automatically show "Saturday". Is there anyway to have it just be blank?

Thanks.