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?

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

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

Works great. Thanks for the quick reply.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1