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