#1
|
|||
|
|||
Displaying a date as text
Hi, I'm new to excel and quite bad at it, so I'd appreciate some help.
The first problem should be quite easy for you... I need a formula to display today's name (6.1.2011 = Thursday) I've found this formula but for some reason it doesn't work =TEXT(TODAY(),"ddd d") The second problem i have is unsolvable i think :P I have this school timetable which I made for entire year, and I'd like to make one little timetable at the top of spreadsheet which should change as the days pass... So I'd like to have my little table to fetch date from the big timetable. In case you didn't understand... __________________________________________________ _________ |MON 10.1.2011 |_________________________________________________ _________ |Math |Biology |English |_________________________________________________ _________ I want to make a table that'll basically copy this one if 10.1.2011 is today's date. Thanks. |
#2
|
||||
|
||||
The formula should work, but perhaps without any spaces between the "d"s, for example:
Code:
=TEXT(TODAY(),"dddd") Cheers, |
#3
|
|||
|
|||
I had already written the formula without the empty space between the d's, the weird thing is... it says that the formula is wrong and underlines dddd.
Here's the picture, I hope it'll help you: http://img524.imageshack.us/i/72970040.png/ Thanks for the reply. Oh, and if you didn't know I have an 2010 office copy. |
#4
|
||||
|
||||
Hi Mandusin,
You're making this harder than it needs to be. Simply enter =TODAY() into the cell where you want the date to appear. Then choose Format|Format Cells|Date and select a date with the appropriate format. If you can't find one there, choose 'Custom' instead of 'Date' and use a custom format. For waht your first post describes, the format would be: DDD d.m.yyyy The second problem would require a lookup table with the classes for each day.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thanks for the reply, I didn't notice "custom" category in format cells menu...
I guess I'll just have to work around for my second problem. Thanks. |
#6
|
||||
|
||||
Hi Mandusin,
Take a look at the workbook in the second-last post in this thread: https://www.msofficeforums.com/excel...la-please.html That should give uou an idea of how to go about it.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Sorry for reopening the thread.
I've got an idea but I'm not sure how to make it work, I'll attach excel file, maybe you'll think of something. Sorry to bother you again. |
#8
|
||||
|
||||
Hi Mandusin,
The formula for C6 is: =INT(TODAY()/7)*7+2 The formula for C13 is: =INT(TODAY()/7)*7+3 and so on.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Thanks very much! your help is appreciated
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Graphs: how to stop displaying a value | thorgal67 | Excel | 2 | 12-17-2010 07:59 AM |
Anyway to determine time/date of text creation? | pureride | Word | 1 | 01-05-2010 02:09 PM |
help to convert swf to avi for displaying in ppt? | Frederick | PowerPoint | 1 | 09-13-2009 08:10 PM |
new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
Imported message date change to today's date | promark | Outlook | 1 | 12-23-2005 07:21 AM |