I need a routine that will add so many days to another cell depending on the
contents of a particular cell.
I have a cell (J2) that has W (for weekly), B (for Bi Weekly), or M (for
Monthly). When cell N2 (Last date) is updated with a new date, I need to
add 7 days if J2 has a W, or 14 days if J2 has a B or 30 Days id J2 contains
an M. and put the new date in cell L2 (the new due date),

Cell L2 contains the Due Date.... the one that needs to be updated after the
calculation
Cell J2 contains the info to base the calculation on W, B, or M
Cell N2 contains the old due date that is used to start the calculation

Any help is greatly appreciated.

Jonco