You're lucky that XL's dates are incremented by the day.

So, just add the number of days to a cell containing the start date.

A1 = 1/1/06

B1 = 10

C1 contains this formula:
=A1+B1
C1 displays
1/11/06


So make Column A your start date,

Leave Column B for your duration (days), which you will manually key in,

And enter this formula in Column C:

=IF(AND(A10,B10),A1+B1,"")

This will leave Column C empty, until you enter values in Column A and B.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"Mr Mr" wrote in message
...
I have done for the last 2 years counted forward when my repete priscription
is due (medication)

I have a spead sheet and my calander. I have been manualy inputting the
dates to remind me.

Help.

Yep there is a fast way but Im new at this.

What I do. I have meds just arrived on 22/08/06 these last for 56 days
(8weeks) so I would like to enter in a cell the last date i received them
and a period of how many I received (days) this will then give me the next
date it is due for repete.

Not all my meds are 56 day. some are 28 & 84

Hope you understand. Thanks for looking.