01/01/2006 28 38746



Tried it but it gives above result.

Im in the UK, my date format is day/month/year could this be the reason Im
gettind 38746 instead of 29/01/2006 ???



I have found a slow but it works method, but would prefair fater one.

Thanks for you help!!


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Med name in Column A

Received date in Column B

Number of days in Column C

In Column D is renew date.

In D2 enter =IF(OR(B2=0,C2=0),"",B2+C2)

Copy down D as far as you want.


Gord Dibben MS Excel MVP

On Sat, 26 Aug 2006 16:01:05 GMT, "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.