Mr Mr wrote:
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.

Hi,

try this

=DATE(YEAR(A1),MONTH(A1),DAY(A1)+B1)

where in A1 is the starting date (i.e. 22/08/06) and B1 is the number of
days to add to the starting date (i.e. 56 or 28 or 84 or wvery number of
days you need...).

You can also find some useful template he

http://office.microsoft.com/en-us/te...482901033.aspx

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy