Today Function

S

stevestrib

I created a calendar using conditional formatting that runs with the today
function. Past days are red, current day black and future days green. Can I
create a web page that still utilizes the today function.
 
G

Gary''s Student

Sure. for Excel 2002 and up

Open a fresh clean worksheet and in cell A1 enter:
=TODAY()

Then:

File > Save as WebPage

The result is an .htm file that can be directly opened with IE or Excel.

The result of today() will appear in both applications.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
Creating a web page 0
Use TODAY() function as the criteria in a SUMIF formula 1
Conditional Formatting question.... 1
Conditional Formatting 2
Calendar using TODAY function 0
Conditional formatting with dates 7
Help creating new functions for Excel 2013 4

Top