Thread
:
This should not be so difficult but it is to me dates for medi
View Single Post
#
10
Posted to microsoft.public.excel.worksheet.functions
bigisle
external usenet poster
Posts: 9
Got Macros and it did update, but the dates ALL changed not just t
OK I got the macros to work !!!
I just sent you an e mail to your hotmail now what to do.
It DID change! But did change ALL of them, even if the date has
not yet come.
Are the dates tied into the calendar on my computer or not?
Anyway for the formula to know not to change the 30 days until the
date is the same on the computer???
Thank you Antoinette
"bigisle" wrote:
OK I just got it opened on my lap top.
In excel. Whoppie.
I will take it with me when I have to leav
for the hour and study it and let you know.
You are such a sweetie for helping me at all!
God Bless people like you!
Antoinette
"ryguy7272" wrote:
Ok, I didn't see any files from you. Can you resend?
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"bigisle" wrote:
Thank you very very very much! I just sent a better description and the two
files to you. One in excel and one in Words .doc.
Antoinette
"ryguy7272" wrote:
Sounds a little confusing but I don't think it's too bad actually. Send it
my way and I'll work on it tonight.
Also, give me a before and after sample please; use two sheets or whatever
is easiest to demo it.
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"bigisle" wrote:
I"ve been working 2 solid days on trying to just figure out HOW to have two
date columns change the way I want them to. I KNOW it must be able to be
done in EXCEL but darned if I can figure it out. I have a medicine sheet
that has the date I last filled my prescription, then the date it can be
filled again. The time is 30 days from the first column of last filled.
THIS I think I have figured out how to do for the formula and tie it into the
computers calendar. BUT THEN I need that 2nd column to take it's new 30 days
back to the first column, so it now becomes the last filled date and then
there is another 30 days in the 2nd column; as these will change every 30
days. Is this so difficult? Or am I not explaining it clearly? I can attach
the spread sheet to any e mail if anyone has one and wants to see what I am
trying to do. Thank you very much Antoinette I have Windows Office 2007 for
my Excel
Reply With Quote
bigisle
View Public Profile
Find all posts by bigisle