ExcelBanter - Today Function

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Today Function (https://www.excelbanter.com/new-users-excel/176214-today-function.html)

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.
--
Gary''s Student - gsnu200768

"stevestrib" wrote:

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.