| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas that calculate to errors on one computer but not on anoth | Excel Worksheet Functions | |||
| Array formulas change outcome on a German computer? | Excel Discussion (Misc queries) | |||
| Create an "on my computer" menu command | Setting up and Configuration of Excel | |||
| How do I create a form that can be filled in on the computer | Excel Discussion (Misc queries) | |||
| create a inventory of files on computer in excel | Excel Discussion (Misc queries) | |||
Linear Mode
