This should not be so difficult but it is to me re: dates for medi

[bigisle]

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

 

[ryguy7272]

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.
(e-mail address removed)

Also, give me a before and after sample please; use two sheets or whatever
is easiest to demo it.

 

[bigisle]

WHOWIE WHOWIE WHOWIE!!! You would really do this for me? I'd SO appreciate
it! I have seizures and have even gone temporarily bind on computers so I
really have to limit my time which makes it almost impossible to get anything
done. I even had to give up making my great .gifs.
My husband and I even tried working together on it a whole day. We didn't
think we were too "stupid" but this is a whole different kettle of fish than
what I was trained for as an RN and my husband who is a contracting officer.
I will be very happy to send you what you request.
I am ever SOooooooooooooo APPRECIATIVE!!!! Gosh! This is what I really need!
Thank you Thank you THank you!
Antoinette (bigisle)

 

[bigisle]

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]

Ok, I didn't see any files from you. Can you resend?
(e-mail address removed)

 

[bigisle]

Aloha Ryan:

I just re sent the two pages to your hotmail address (e-mail address removed)
I hope you receive it. Please let me know. One is in Word and the other I
have put the same info in an Excel spreadsheet what I need to have the
formulas for the DATES columns please.
Thank you VERY much,
Antoinette

 

[bigisle]

I re sent the info to you at your hotmail addy. Hope you get it this time,
please
let me know. At your convenience.
Antoinette

 

[bigisle]

I just sent you an e mail to your hot mail addy. It came in encrypted (I
think)
You are using Excel 2003 mine is 2007 so I re sent the document as an .xls
instead of the .xlsx it was. Hope this helps and it is not too much more
trouble for
you to transfer the into to that. Or maybe you can just save the document
as an
xlsx?
Thank you again Really excited to see what you have done.
Go check your hotmail e mail OK?
Antoinette

 

[bigisle]

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

 

[bigisle]

OK I got the macros to work !!!
I just sent you an e mail to your hotmail re: 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