LinkBack URL
About LinkBacks
I am tring to put the day of the week in one cell, the month is in another cell and the year in another. I want this to auto update when the month and year are changed.
I am tring to put the day of the week in one cell, the month is in another cell and the year in another. I want this to auto update when the month and year are changed.
Hello & Welcome to the Board,
Are you saying spread out across three cells you have the day, month, and year and you want all of this in one cell? When you change one of those variable the date will update?
If so,
=DATE(C1,B1,A1)
C1 = Year
B1 = Month
A1 = Day
HTH
Regards, Jeff
Not too clear on what you are working with. If you place =TODAY() in the three cells and then custum format
the first one as dddd
the second as mmmm
the third as yyyy
Does that help?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I have
C1 = Year
B1 = Month
A1 = Date
I need the day mon, tue on the first letter
Hi
in D1 enter
Format the cell as "ddd"
Please Login or Register to view this content.
It will display the day name
see attached also
Regards
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks