Trying to calculate week start using countif but the calculation seems to be wrong

dishank.jain112376

I'm trying to calculate count of dates using the formula CountIF([date]:[date],"11/25/2019")

Wherever i have the date as 11/25/2019, it should give me the count, it should give me the total count.

But the formula isn't giving any data using this formula

Phil Wightman

Hi there, 

I use the sum(date-date) function to count days to a date in the future if that helps.

 

Paul Newcome

When referencing a date in a formula, you need to use the DATE function.

 

=DATE(yyyy, mm, dd)

.

COUNTIFS([date]:[date],@cell = DATE(2019, 11, 25))

.

Give something like that a try.