Hi,

I am new to the world of excel and I am trying to create a spreadsheet that has a few basic/advance functions.

1. I would like excel to be able to automatically figure out that my 'no of weeks field' is actually X amount of months. i.e. if I was to enter the number 16 into the field it would return a value of '4' for months. If 17 then 4.1.... is this possible? if so, please may you help guide me in how I could implement this into my spreadsheet.

I look foward to any response.

Thanks in advance,

Karo