Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 07:59 PM
mikelove
 
Posts: n/a
Default how do i set up a cell in excel so that it shows the current date

I have made a calendar in excel that i really like. Everyday when I open
that calendar I want it to show the current date how do i do this. Or can i
make it so that it highlights the cell in my calendar of the day it is.

thanks

  #2   Report Post  
Old May 16th 05, 08:07 PM
Peo Sjoblom
 
Posts: n/a
Default

You can do either, if you want today's date you can use =TODAY()
in a cell and then just add the days so if A2 is today's date A3 might be
A2+1 etc or you can use conditional formatting and a fixed dates, select all
dates and assume A2 is the active cell (the cell where you first selected
from), then use formatconditional formatting , formuoa is and

=A2=TODAY()

then click the format button and select a pattern and click OK twice


Regards,

Peo Sjoblom

"mikelove" wrote:

I have made a calendar in excel that i really like. Everyday when I open
that calendar I want it to show the current date how do i do this. Or can i
make it so that it highlights the cell in my calendar of the day it is.

thanks

  #3   Report Post  
Old May 16th 05, 08:12 PM
Fred Smif
 
Posts: n/a
Default

try these cell formulas:

=TODAY() 'gets you the date
=NOW() 'gets you the date and time
=WEEKDAY(serial number, return type) 'gets you the day of the week as
an index number; see Help

then try this formula:

=CHOOSE(WEEKDAY(TODAY(),1), "Sunday", "Monday", "Tuesday", "Wednesday",
"Thursday", "Friday", "Saturday")


"mikelove" wrote in message
...
I have made a calendar in excel that i really like. Everyday when I open
that calendar I want it to show the current date how do i do this. Or can
i
make it so that it highlights the cell in my calendar of the day it is.

thanks





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. PboB Excel Discussion (Misc queries) 3 March 16th 05 07:17 PM
Excel: how to formulate conditional cell references centraloffice Excel Worksheet Functions 1 December 10th 04 09:57 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 05:55 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017