Thread: how can I format a cell to change on a specific date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default how can I format a cell to change on a specific date
Typo correction:
To test that the CF works,
just change the date to a current date, eg:
=AND(A1="Active",TODAY()= --"15 Sep 2008")

The test formula should have read as (but of course<g):
=AND(A1="Active",TODAY()= --"15 Sep 2007")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote