Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates formula problem
I am using excel 2003.
I tried to get my sales per quarter in one cell, so I have two columns, one for the date, the other one is my sales revenues. I dont have problem with one argument, but I dont know how to integrate the second argument. If I applied this function in my cell: =SUMIF(C24:C300,"=39172",D24:D300) it works for all date since 39172. But how can I integrate: and =<39172. to get sales from my first quarter. You understand that I worked with the numbers of day since 1900, because I dont know, how to use date value formula. -- Any suggestions would be greatly appreciated. Andre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dates problem | Excel Discussion (Misc queries) | |||
Dates Problem | Excel Discussion (Misc queries) | |||
Problem with dates | Excel Discussion (Misc queries) | |||
Problem Dates | Excel Discussion (Misc queries) | |||
Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) |