T
texcel
Hello Excel Forum! Good day to you all. Question I been grappling with:
ISSUE TO BE SOLVED:
At my business there are Maintenance Tasks that must be done on th
SAME DAYS Year in and Year out.
These Tasks are separated into FIXED Daily, Monthly, Annual an
Bi-Annual APPOINTMENTS
For example, Computer Software must be reinstalled on January 1 (1/1
EVERY YEAR no matter what year it is.
I would like a Formula that would be able to DISPLAY the DAY and MONT
of the TASK APPOINTMENT—e.g 1/1 from above—ALONG WITH the CURRENT YEA
so that each year the TASKS are listed next to a COMPLETION DAY tha
displays the FIXED DAY and MONTH as well as the CURRENT YEAR.
To build on the above mentioned example, the Computer Softwar
Installation would have the corresponding COMPLETION DATE of 1/1/200
in 2004 and 1/1/2005 in 2005, 1/1/2006 in 2006 and so on.
PURPOSE:
I want this so that task appointment dates can be SEEN and USED A
REFERENCES in more Excel calculations .
Things I would like to calculate from the TASK APPOINTMENTS are th
number of Days that remain BEFORE the next Task Appointment and, i
necessary, the number of Days we are BEHIND it.
MY EFFORTS:
This is how I have organized the Heading Row for the Spreadsheet.
"A. Fixed Appt.Date" "B. Last Completion Date" "C. Next Appt.Date"
"D. Days Until/ Behind
"A. 01/01" "B. 01/01/04 " "C
07/01/05" "D. =C. NxtApt.Date – TODAY()
MY CONCLUSION:
Next Appt. Date is what I want to automatically update and I think i
needs to refer to the “Fixed Appt. Date”
BOTTOM LINE:
How do you add a FIXED MONTH AND DAY with the CURRENT YEAR in a manne
that will allow me to perform Formulas on it?
Please Respond,
Thanks
Texce
ISSUE TO BE SOLVED:
At my business there are Maintenance Tasks that must be done on th
SAME DAYS Year in and Year out.
These Tasks are separated into FIXED Daily, Monthly, Annual an
Bi-Annual APPOINTMENTS
For example, Computer Software must be reinstalled on January 1 (1/1
EVERY YEAR no matter what year it is.
I would like a Formula that would be able to DISPLAY the DAY and MONT
of the TASK APPOINTMENT—e.g 1/1 from above—ALONG WITH the CURRENT YEA
so that each year the TASKS are listed next to a COMPLETION DAY tha
displays the FIXED DAY and MONTH as well as the CURRENT YEAR.
To build on the above mentioned example, the Computer Softwar
Installation would have the corresponding COMPLETION DATE of 1/1/200
in 2004 and 1/1/2005 in 2005, 1/1/2006 in 2006 and so on.
PURPOSE:
I want this so that task appointment dates can be SEEN and USED A
REFERENCES in more Excel calculations .
Things I would like to calculate from the TASK APPOINTMENTS are th
number of Days that remain BEFORE the next Task Appointment and, i
necessary, the number of Days we are BEHIND it.
MY EFFORTS:
This is how I have organized the Heading Row for the Spreadsheet.
"A. Fixed Appt.Date" "B. Last Completion Date" "C. Next Appt.Date"
"D. Days Until/ Behind
"A. 01/01" "B. 01/01/04 " "C
07/01/05" "D. =C. NxtApt.Date – TODAY()
MY CONCLUSION:
Next Appt. Date is what I want to automatically update and I think i
needs to refer to the “Fixed Appt. Date”
BOTTOM LINE:
How do you add a FIXED MONTH AND DAY with the CURRENT YEAR in a manne
that will allow me to perform Formulas on it?
Please Respond,
Thanks
Texce