Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find an average date
I would like to be able to do the following:
B12:B50 are all various dates, which include 2007 & 2008. F12:F50 = IN or F12:F50 = OT When Col F = IN, return the average date from B12:B50 in one cell and when Col F = OT, return the average date from B12:B50 in another cell. I've looked in the previous posts and can't find anything that works. Thanks to anyone who can help. Christy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
select date range then find average of values in another cell | Excel Worksheet Functions | |||
How to find average for grading? | Excel Worksheet Functions | |||
How do I find the average time? | Excel Worksheet Functions | |||
Using Sumproduct to Find Average | Excel Discussion (Misc queries) |