Ok, so I unmerged the cells, and the formula worked however, it is not counting v as .50 a day, both v & V are counting as 1.