Excel - Insert "day" on a cell and format it to date with current month and year -

i working on home accounting template (and not find 1 :-/), creating 1 each month. both in expenses , incomes, have date column have insert "day" (e.g.: 22) , automatically fills rest current month , year (or set them in cell).

for example: 22 + enter return: 22/12/2014

if this, automatically default date: 22/01/1900

i not know if possible change defaul date depending on current 1 or other value.

i have tried different strategy: if amount column not empty, fill in today's date: =if(a3="";"";today())

the problem not register today's expenses, need change manually. wondering if possible , there better way (maybe macro?).

you need excel modify cell contents after press enter. option seems macro using worksheet_change event.

please check out this other question. think help.