P
Phillip M. Jones, C.E.T.
Okay you folks are going to laugh big time.
I have to look after my aged parents, taking them to Dr's appointments and the like.
We used to be able to buy desktop calendars about the sixe businesses would
give away such as funeral homes, Heating Oil Companies. about 4x5 inches or so.
They use them to write down appointments and the like and sit it on top of the
TV where they can see it.
I can create such in excel. but I have to manually type in two numbers and
create two formula =sum(column/row number +1) (example =sum(A1+1) ) for ist row.
and =sum(column/row number +7) (example =sum(A1+7) ) for first column then
option Drag formula down or across to fill in rest of the days.
Is there any way that I can create one so that next year all I have to do it
move the day over one and the rest of the calendar will automatically update.
In other words next year I want to open the file make one change and the whole
calendar will be good to go for the year.
--
---------------------------------------------------------------------------
Phillip M. Jones, CET |MEMBER:VPEA (LIFE) ETA-I, NESDA,ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112-1809 |[email protected], ICQ11269732, AIM pjonescet
---------------------------------------------------------------------------
If it's "fixed", don't "break it"!
mailto
[email protected]
<http://www.kimbanet.com/~pjones/default.htm>
<http://home.kimbanet.com/~pjones/birthday/index.htm>
<http://vpea.exis.net>
I have to look after my aged parents, taking them to Dr's appointments and the like.
We used to be able to buy desktop calendars about the sixe businesses would
give away such as funeral homes, Heating Oil Companies. about 4x5 inches or so.
They use them to write down appointments and the like and sit it on top of the
TV where they can see it.
I can create such in excel. but I have to manually type in two numbers and
create two formula =sum(column/row number +1) (example =sum(A1+1) ) for ist row.
and =sum(column/row number +7) (example =sum(A1+7) ) for first column then
option Drag formula down or across to fill in rest of the days.
Is there any way that I can create one so that next year all I have to do it
move the day over one and the rest of the calendar will automatically update.
In other words next year I want to open the file make one change and the whole
calendar will be good to go for the year.
--
---------------------------------------------------------------------------
Phillip M. Jones, CET |MEMBER:VPEA (LIFE) ETA-I, NESDA,ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112-1809 |[email protected], ICQ11269732, AIM pjonescet
---------------------------------------------------------------------------
If it's "fixed", don't "break it"!
mailto
[email protected]<http://www.kimbanet.com/~pjones/default.htm>
<http://home.kimbanet.com/~pjones/birthday/index.htm>
<http://vpea.exis.net>