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/

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/