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.

"texcel" wrote:


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 or
January 1) EVERY YEAR€¦

** DESI

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

With the previously described desire the cell would
display€“THU/1/1/2004€“for the remainder of this year and next year it
would display€“SAT/1/1/2005

PURPOSE:

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


** DESI 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 Date
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 THE
WEEK€� that the €œFixed Numerical Month and Day€� falls upon DURING THE
€œ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 whatever
Formula€¦

I want the €œCURRENT YEAR€� and the €œDAY OF THE WEEK€� that the €œFIXED
MONTH and DAY€� fall upon during the €œCURRENT YEAR€� to ALL UPDATE
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:00AM


--
texcel
------------------------------------------------------------------------
texcel's Profile: http://www.excelforum.com/member.php...fo&userid=4325
View this thread: http://www.excelforum.com/showthread...hreadid=274211