#NAME? Error, need help to fix, I can't find the problem.

Hi Everyone

I am having a bit of trouble with one of my formula's. I have this formula on another excel spreadsheet and it works fine, but when i re-typed it onto a new spreadsheet I need it comes up with the name error. I cannot think of what it could be. Any help would be greatly appreciated. Please find the spreadsheet attached below:

Basically what I would like to happen is that you enter the date into coloumn A and when I type a number into the corresponding cell in coloumn E (you will see a key in coloumn O and P) i would like cell K5 to display with a due date

I know that I do not need macro's as I have another spreadsheet that doesnt use them. Ifyou need any help with this then just let me know

Regars
Rhiannon

Sorry I added the wrong spreadsheet.

Here is the correct one.Site Access Tracking Sheet.xls

Hi Fotis

I uploaded the wrong spreadsheet please see the new one under my original post.

Also if i typed today's date in coloumn A5 and in E5 i put 1, then in K5 the result would be the date 1 week from today.

You should be able to see the key in coloumn O and P but if not here it is:

VALIDATION TIMES
1 Week = 1
1 Month = 2
3 Months = 3
6 Months = 4
1 Year 5

Im not sure what the DateSwitch is, to get the first spreadsheet to work the first time i posted it onto this website and thats the formula i was given and it worked.

As for your second question, yes that is what I woud like to happen

try this

=IF(AND(A5<>"",E5<>"",E5=1),DATE(YEAR(A5),MONTH(A5)+1,DAY(A5)+7),IF(AND(A5<>"",E5<>"",E5=2),DATE(YEAR(A5),MONTH(A5)+3,DAY(A5)+30),IF(AND(A5<>"",E5<>"",E5=3),DATE(YEAR(A5),MONTH(A5)+3,DAY(A5)),IF(AND(A5<>"",E5<>"",E5=4),DATE(YEAR(A5),MONTH(A5)+6,DAY(A5)),IF(AND(A5<>"",E5<>"",E5=5),DATE(YEAR(A5)+1,MONTH(A5),DAY(A5)),"")))))

Thank Fotis, your formula worked, except that after i entered the date in coloumn A and before i entered 1-5 in coloumn E it would show up with false in coloumn k. But thank-you for your help

and @supermansaja your formula fixed the problem I was having with my original formula and stayed blank until all the information was added, so thank-you