need help including =EDATE in a nested if statement

[excvtr]

i have a formula that i want to increase the typed in date by a week, month, or year, but am having trouble putting in the "edate function

my formula is as follows:

=IF(F8="WEEKLY",I8+6,=IF(F8="MONTHLY",I8+30,=IF(F8="YEARLY",I8+365,"")))

i want to replace the +30, and the +365 with and edate function

any help would be greatly appreciated

 

[AlphaFrog]

Try this...

=IF(F8="WEEKLY",I8+6,IF(F8="MONTHLY",EDATE(I8,1),IF(F8="YEARLY",EDATE(I8,12),"")))

 

[Momentman]

when you say I8+30, if you want a month after I8, then you can use maybe =edate(I8,1), the "1" indicates 1 month and for that of 365, =edate(I8,12) where 12months is equiv to 365days