Repete Dates at a value of 28 days, 56 & 84
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.
|