Repete Dates at a value of 28 days, 56 & 84

  • Thread starter Thread starter Mr Mr
  • Start date Start date
M

Mr Mr

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(A1>0,B1>0),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!
=====================================================



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
 
Mr said:
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.
Click to expand...

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 here:

http://office.microsoft.com/en-us/templates/CT010482901033.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!!
 
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!
=====================================================

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!!
 
Back
Top