Hello,

I have a workbook full of differnt dates. To make entering data (the dates) quicker, I had previously thought of formatting the cell in the following way so that it was possible to enter only a number to turn into a date: "June" 0", 2014"

Using the above formatting, I could enter 27 only and it work format correctly to June 27, 2014.

However, the problem I am running into now is when the month changes. It is annoying to change the format of the cells every month.

Is it possible to format a cell using what is in a certain cell? For example, if I type "July" into A2 and "2015" into A3, could I somehow use those cells to format the cell correctly when only entering in a number like above.

Let me know if this is clear.