i have a boarding house that is rented by rooms.
tenants start the tenancy at different times of the week eg 28/10/2013
i want to be able to add 13 days to the beginning date and excel can calculate the paid to date

i have tried it in excel 2007 but i keep getting a #value error. However i have formatted the date cell as date and the number cell

my formula looks like this 28/10/13 (formatted as date english australia) + 13(formatted as number)= cell (formatted as date)

any ideas would be appreciated

arthur