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.

How do you create formulas using the date on the computer?
 

=if(specific condition,A1,"")

--
Regards,
Tom Ogilvy

"Information Hog" <Information wrote in
message ...
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.