Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2011, 04:00 AM
Mandusin Mandusin is offline Displaying a date as text Windows 7 64bit Displaying a date as text Office 2010 64bit
Novice
Displaying a date as text
 
Join Date: Sep 2010
Posts: 9
Mandusin is on a distinguished road
Default 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.


Reply With Quote
  #2  
Old 01-06-2011, 10:32 AM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Displaying a date as text Windows XP Displaying a date as text Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

The formula should work, but perhaps without any spaces between the "d"s, for example:

Code:
=TEXT(TODAY(),"dddd")
The second problem will depend on how your spreadsheet is arranged. It would be helpful if you'd post a sample of your timetable spreadsheet; with sensitive info changed/removed of course.

Cheers,
Reply With Quote
  #3  
Old 01-06-2011, 12:34 PM
Mandusin Mandusin is offline Displaying a date as text Windows 7 64bit Displaying a date as text Office 2010 64bit
Novice
Displaying a date as text
 
Join Date: Sep 2010
Posts: 9
Mandusin is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 01-06-2011, 03:07 PM
macropod's Avatar
macropod macropod is offline Displaying a date as text Windows 7 32bit Displaying a date as text Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #5  
Old 01-07-2011, 02:56 AM
Mandusin Mandusin is offline Displaying a date as text Windows 7 64bit Displaying a date as text Office 2010 64bit
Novice
Displaying a date as text
 
Join Date: Sep 2010
Posts: 9
Mandusin is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 01-07-2011, 03:04 AM
macropod's Avatar
macropod macropod is offline Displaying a date as text Windows 7 32bit Displaying a date as text Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #7  
Old 01-07-2011, 08:29 AM
Mandusin Mandusin is offline Displaying a date as text Windows 7 64bit Displaying a date as text Office 2010 64bit
Novice
Displaying a date as text
 
Join Date: Sep 2010
Posts: 9
Mandusin is on a distinguished road
Default

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.
Attached Files
File Type: xlsx Kalendar.xlsx (81.0 KB, 17 views)
Reply With Quote
  #8  
Old 01-07-2011, 01:43 PM
macropod's Avatar
macropod macropod is offline Displaying a date as text Windows 7 32bit Displaying a date as text Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #9  
Old 01-08-2011, 02:34 AM
Mandusin Mandusin is offline Displaying a date as text Windows 7 64bit Displaying a date as text Office 2010 64bit
Novice
Displaying a date as text
 
Join Date: Sep 2010
Posts: 9
Mandusin is on a distinguished road
Default

Thanks very much! your help is appreciated
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying a date as text 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
Displaying a date as text 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
Displaying a date as text Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft