If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add a FIXED MONTH and DAY with the CURRENT YEAR
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 the SAME DAYS Year in and Year out. These Tasks are separated into FIXED Daily, Monthly, Annual and 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 MONTH of the TASK APPOINTMENT—e.g 1/1 from above—ALONG WITH the CURRENT YEAR so that each year the TASKS are listed next to a COMPLETION DAY that displays the FIXED DAY and MONTH as well as the CURRENT YEAR. To build on the above mentioned example, the Computer Software Installation would have the corresponding COMPLETION DATE of 1/1/2004 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 AS REFERENCES in more Excel calculations . Things I would like to calculate from the TASK APPOINTMENTS are the number of Days that remain BEFORE the next Task Appointment and, if 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 it 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 manner that will allow me to perform Formulas on it? Please Respond, Thanks Texcel --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Add a FIXED MONTH and DAY with the CURRENT YEAR
Texcel,
For a date in cell A1: =DATE(YEAR(NOW()),MONTH(A1),DAY(A1)) HTH, Bernie MS Excel MVP "texcel " wrote in message ... 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 the SAME DAYS Year in and Year out. These Tasks are separated into FIXED Daily, Monthly, Annual and 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 MONTH of the TASK APPOINTMENT-e.g 1/1 from above-ALONG WITH the CURRENT YEAR so that each year the TASKS are listed next to a COMPLETION DAY that displays the FIXED DAY and MONTH as well as the CURRENT YEAR. To build on the above mentioned example, the Computer Software Installation would have the corresponding COMPLETION DATE of 1/1/2004 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 AS REFERENCES in more Excel calculations . Things I would like to calculate from the TASK APPOINTMENTS are the number of Days that remain BEFORE the next Task Appointment and, if 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 it 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 manner that will allow me to perform Formulas on it? Please Respond, Thanks Texcel --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|