Thanks Martin for guidance. The F9 didn't work. Upon closer investigation I found that if I replaced my original data entries for "Month end date" of say 1/4/2014 with just 1/4, THEN the cell would automatically go to 1/4/2015 and the calculations made correctly. I have manually changed all cells for Month End Date and Date of Month to the simplified format and all is well.