COUNTIF formula with a date

Marcy

Hello,

 

I am new to this, this is probably a simple formula I am trying to use but I can't seem to make it work. (I have read through the forums and tried all sorts of suggetions that I have found)..

 

I have a column that has a date field, and some rows have dates entered, some do not. I need to reference on a sperate sheet how many columns have a date entered. Just a simply count, that will be automatically updated each time a date is added or deleted. 

 

Any tips? 

 

Thanks!! 

J. Craig Williams

Marcy, 

 

You are going to need a few different functionality pieces.

 

1. Getting the count of dates entered:

 

This will work even if your Date columns are mixed with other column types -- but only if you don't want to skip some Date columns.

 

=COUNTIF(StartDate23:EndDate23, ISDATE(@cell))

 

This will look at all the columns on row #23 from the [StartDate] column to the [EndDate] column. In my sheet, that's 5 different dates.

When they are filled, the number will increase.

 

You'll want to put that formula in a cell (not a Date column and not in the range you are looking for).

 

2. To get this number to another sheet:

 

Use cell linking.

https://help.smartsheet.com/articles/861579-cell-linking

 

Hope this helps.

 

Craig

 

 

Marcy

This worked great, thank you so much!