Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |