Combine & Display “Fixed” & “Automatically Updated” Date Parts

[texcel]

Hello Excel Forum! Good day to you all. Question I been grappling with:


ISSUE TO BE SOLVED:

My Work Season starts every year on a FIXED MONTH and DAY (1/1 o
January 1) EVERY YEAR…

** DESIRE:

I want a Formula that will DISPLAY the FIXED DAY and MONT
(NUMERICALLY) that my Work Season starts—1/1—ALONG WITH the “CURREN
YEAR” and THE “DAY OF THE WEEK” that the FIXED DAY and MONTH fall o
(e.g Fri, Sat, Sun, etc) DURING THE CURRENT YEAR.

With the previously described desire the cell woul
display–THU/1/1/2004–for the remainder of this year and next year i
would display–SAT/1/1/2005

PURPOSE:

I want this so that the exact Start Dates of my Work Season can be SEE
and USED AS REFERENCES IN MORE EXCEL CALCULATIONS such as adding o
subtracting dates


** DESIRE: IN OTHER WORDS:

I want a cell that will DISPLAY all of the below-listed “PARTS OF DATE
TOGETHER WITHIN IT in a manner that will allow me to perform Dat
Calculations on it.


1. A “FIXED NUMERICAL MONTH AND DAY” EVERY YEAR THAT WILL NOT CHANGE:

1/1


2. AFTER THE “FIXED NUMERICAL MONTH and DAY” I want THE “CURRENT YEAR
to display and to AUTOMATICALLY UPDATE EVERY YEAR:

For the remainder of this year (2004) it would AUTOMATICALLY read:

1/1/2004

And next year (2005) it would AUTOMATICALLY read:

1/1/2005

And in 2006 it would AUTOMATICALLY read:

1/1/2006


3. AND BEFORE THE DATE (1/1/2004, 1/1/2005, etc) I want THE “DAY OF TH
WEEK” that the “Fixed Numerical Month and Day” falls upon DURING TH
“CURRENT YEAR”


** SO THAT, ALTOGETHER THE CELL WOULD DISPLAY:

For the remainder of this year (2004) the cell would display:

THU/1/1/2004

And next year (2005) the cell would display:

SAT/1/1/2005

And in 2006 it would display

SUN/1/1/2006


PLEASE NOTE:

The FIXED NUMERICAL MONTH and DAY remain constant and…

Once I enter the FIXED NUMERICAL MONTH and DAY along with whateve
Formula…

I want the “CURRENT YEAR” and the “DAY OF THE WEEK” that the “FIXE
MONTH and DAY” fall upon during the “CURRENT YEAR” to ALL UPDAT
AUTOMATICALLY EVERY YEAR

THANKS FOR YOUR CONSIDERATION AND PLEASE RESPOND IF YOU CAN,

Thanks

Texcel

P.S. If you can do the above described…

Is there any way to add a “FIXED TIME” to the Display e.g
SAT/1/1/2005/6:00pm, SUN/1/1/2006/12:00A

 

[Guest]

Use the formula;
=Date(year(now()),1,1)

Format the cell using custom and enter
Ddd/m/d/yyyy

This will allow you to use the cell as a date number as well. If you want
it as text you would use the same formula above but include it in the text
function as follows:
=text(date(year(now()),1,1),"Ddd/m/d/yyyy")

That should do it. The only thing is, is you'll need that on each workbook.