# Formula for calculating a new date based on an existing date and other cell criteria

1. ## Formula for calculating a new date based on an existing date and other cell criteria

I have a SS that contains a date cell, entered by the user. There are other adjacent cells that are populated by formulas based on the contents of other cells. Here is what I need to do:

If cell D3 contains an N, cell L3=0, cell I3 contains a date entered by the user then I need cell J3 to calculate a new date (add 14 days). If D3 contains an R and the other cells remain the same then I need to add 7 days to the date in I3 for cell J3.

Here is what I have tried:

=IF( AND(\$L3 =0, AND( \$D3 = "N")),I3+14, "" ) & IF( AND(\$L3 =0, AND( \$E3 = "R")),I3+7, "" )

It is only returning a number in cell J3. What do I have wrong?  Register To Reply

2. ## Re: Formula for calculating a new date based on an existing date and other cell criteria ``Please Login or Register  to view this content.``
Try this one  Register To Reply

3. ## Re: Formula for calculating a new date based on an existing date and other cell criteria

Works great. Thanks for the quick reply.  Register To Reply