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