View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Information Hog Information Hog is offline
external usenet poster
 
Posts: 1
Default How do you create formulas using the date on the computer?

Trying to add cells across several worksheets that correspond to the current
date. There are no dates entered in the cells, all worksheet's are set up the
same. Format's in the cells to be used are text and number. Worksheet's are
set up like a yearly calendar, there would be different criteria for adding
the cells. Want to get information from a specific cell's and put the
information in a different cell, only want the information for the current
date not a running total. Using Excel 2000.