| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I specify a date range = date(2010,4,1 thru 30)
I am trying to use a header in a formula. In A1 I have the month and year
(April 2010). I want to bring in a calculation result from a second page (Daily Log) So I want to know how many guest in the month of April visited. But it has to look up April from the year list. I guess this is what I am trying to accomplish Lookup (A1) April (1-30) 2010 from April Stats sheet on Daily log sheet (A column) add guests logged in (D Column) and result to April Stats B5 I record numbers daily and want to have the totals from one page brought to another page, but need the data to be found for the month |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i get the date & time format 2010/02/17 12:05 in excel | Excel Discussion (Misc queries) | |||
| Auto date in excell 2010 | Excel Discussion (Misc queries) | |||
| Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM | Excel Worksheet Functions | |||
| 2010 date in Excel 2000 | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Threaded Mode
