Large If then to add days to a date

[RayKIII]

I am working on a large if-then statement that I am unsure of how to get it to add days to a date. Field H13 will have a number in it. Depending on that number I need to add weeks (days) to the date in cell K13 and output that new date into L13. I have tried both formulas below but with a date of 1/1/2020 in K13 and any number in H13 it is giving me a date of 1/0/1900 in L13. I have formatted both cells to be a date (*3/14/2012). Any assistance is appreciated.



=IF(AND(H13>=60, H13<=300), L13=K13+14, IF(AND(H13>=360, H13<=900), L13=K13+21, IF(AND(H13>=960, H13<=1500), L13=K13+28, IF(AND(H13>=1560, H13<=2400), L13=K13+35, IF(AND(H13>=2460, H13<=4800), L13=K13+42, IF(AND(H13>=4860, H13<=6000), L13=K13+49, IF((H13>=6060), L13=K13+56,"")))))))

=DATEDIF(AND(H13>=60, H13<=300), L13=K13+14, DATEDIF(AND(H13>=360, H13<=900), L13=K13+21, DATEDIF(AND(H13>=960, H13<=1500), L13=K13+28, DATEDIF(AND(H13>=1560, H13<=2400), L13=K13+35, DATEDIF(AND(H13>=2460, H13<=4800), L13=K13+42, DATEDIF(AND(H13>=4860, H13<=6000), L13=K13+49, DATEDIF((H13>=6060), L13=K13+56,"")))))))

 

[Fluff]

Try removing the L13= from your formula.

 

[RayKIII]

Why is it every time I post here I feel like a complete moron? Thank you for finding my mistake.

 

[Fluff]

You're welcome & thanks for the feedback.