Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting dates in columns in a linked spreadsheet
I have a spreadsheet that contains linked rows of data. Most of the data in
each column consists of dates. At the top of each column I'm using the COUNTA function to total the entries in each column. Problem that I'm having is in some columns it is counting every row in that column whether it has a date or not. I linked the spreadsheet with: =IF(Sheet1!A1="","",Sheet1!A1). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting dates in columns in a linked spreadsheet
Use the COUNT function to count dates (assuming they're true Excel dates).
True Excel dates are really just numbers formatted to look like dates. A1 = 1/1/2008 A2 = text A3 = 1/31/2008 A4 = #VALUE! A5 = FALSE A6 = <empty cell =COUNT(A1:A6) = 2 -- Biff Microsoft Excel MVP "Bernie R." <Bernie wrote in message ... I have a spreadsheet that contains linked rows of data. Most of the data in each column consists of dates. At the top of each column I'm using the COUNTA function to total the entries in each column. Problem that I'm having is in some columns it is counting every row in that column whether it has a date or not. I linked the spreadsheet with: =IF(Sheet1!A1="","",Sheet1!A1). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting dates in a spreadsheet.... | Excel Discussion (Misc queries) | |||
counting occasions dates occur between 2 dates | New Users to Excel | |||
Counting data columns with dates | Excel Discussion (Misc queries) | |||
Counting columns of dates | Excel Discussion (Misc queries) | |||
Counting columns and specific Dates | Excel Worksheet Functions |