Calculating due dates

[Dione]

I am scheduleing appointments for nurses to visit patients. I have the date
that they were last seen and how many weeks before their next visit. Is
there a way to do this easier than counting on a calendar? I am pretty
good at exel and formulas, but I can't seem to figure it out - It's Friday
and my brain is dead. Your help is much appreciated!!
'

 

[Heera]

please explan your requirment properly so that we can give proper
answer.

 

[Gary''s Student]

If A1 contains the date last visited and B1 contains the number of weeks till
the next visit, then:

=A1+7*B1 and format as date.

 

[Niek Otten]

With the date in A1 and the number of weeks in B1:

=A1+B1*7