I want to count how many cells have a date.

I am trying to find a way to count how many cells in my column have a date in it.

I use the formula =COUNT([Target Launch Date]6:[Target Launch Date]24) but it always appears the error code #DATE EXPECTED.

I tried the same formula on other columns with text and it works perfectly fine.

I also tried =COUNTIF([Target Launch Date]6:[Target Launch Date]24, <>"") but it gives the same result.

Can someone help me?

Find more posts tagged with

Formulas

Accepted answers

All comments

Sing C

Hi @Chiara_maz,

I have an example below using COUNT which works as expected.

May I ask where you have the formula? As you can see I created a "Count" column and entered the formula in Row 1 of the column. I'm curious where your formula is.

Thanks,

Sing

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.