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.

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.

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.

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

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.

What you have is XL's date serial number.

Simply format that cell to any date format you would like to see displayed.
--

HTH,

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

"Mr Mr" wrote in message
...
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.

Works Fine and dandy. Cheers everyone

I know where to ask for help!


"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.