Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spreadsheet, several, actually, that have columns containing both
numbers and dates. I want to add accross the colums, but exclude the dates. I didn't realize that it was adding the numeric value of the dates in my end formula, and I don't want to have to do the +c12+e12+g12, etc. Any thoughts on making this easier? I tried storing the dates as text, and that seems to be OK but the stupid error checking is driving me NUTS! I would like to have them formatted as dates, just not included. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how I exclude weekend dates | Setting up and Configuration of Excel | |||
Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
filtering a list to exclude 2 different dates | Excel Worksheet Functions | |||
Is there a way that I can exclude a formula from being printed? | Excel Discussion (Misc queries) | |||
I need to exclude duplicate patient names for dates of service is. | Excel Discussion (Misc queries) |