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!!
'

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

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.
--
Gary''s Student - gsnu200818

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

=A1+B1*7

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dione" wrote in message
...
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!!
'