Today Function

  • Thread starter Thread starter stevestrib
  • Start date Start date
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.
 
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.
 
Back
Top