MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding days to a date formula...


Posted by Loc on February 12, 2002 10:48 AM

Here's the scenario:

Column A is the type of insurance that a patient carries.

Column B is the date of the evaluation or progress note.

Column C is the date that the NEXT progress note is due.

How do I set this up?

If the patient's insurance is MC (Medicare), then Column C will be "Column B plus 30 calendar days"?

Thanks guys. This site is the best!

Loc


Posted by Aladin Akyurek on February 12, 2002 10:59 AM

=B1+30 [NT]

Posted by Loc on February 12, 2002 11:08 AM

But Column A has different insurances...

So how do I plug that in?

Thanks again.

Loc

Posted by Aladin Akyurek on February 12, 2002 11:19 AM

Re: But Column A has different insurances...

Make a 2-column list of insurances and the number of days that must be added like

Medicare 30
etc

Select all of the cells of this 2-column list, go the Name Box on the Formula Bar, type TABLE, and hit enter.

Assuming that the first insurance entry is in A2,

in C2 enter: =B2+VLOOKUP(A2,TABLE,2,0)

and drag this down as far as needed.