Thanks guys, I'll give these a try.

Jonco


"jonco" wrote in message
.com...
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