Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks! The two replies I've gotten have clarified things quite a bit--though
working with dates in Excel always strikes me as a bit complex. Thanks again! "Pete_UK" wrote: The problem is that to Excel a date is just a number, so how could you exclude one number and not another? Numbers that represent recent dates are all in the 38,000 range (eg today is 38811), so if the other numbers are very much lower than this, then you could make use of this to exclude the dates, eg something like: =SUMIF(A1:A1000,"<"35000,A1:A1000) if the column with the mixed data is A. Hope this helps. Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pre-1900 dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
US dates to UK?? | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) |