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?
Bookmarks