# Formula for counting dates in a month

Options

I need to count how many jobs there were per month on another sheet, any tips on how to make the "COUNTIF" or "DATE"

My current formula for the month of January that comes up as "Unparseable"

=COUNTIFS({Date}, AND((>=DATE(2024,1,1), <=DATE(2024,1,31))))

{Date} is the column from the other sheet

Help would be appreciated

• ✭✭✭✭✭
Options

Since you are using COUNTIFS, AND function is no longer needed. Can you try this -

```=COUNTIFS(
{Date}, >=DATE(2024,1,1),
{Date}, <=DATE(2024,1,31)
```

...

• ✭✭✭✭✭
Options

Since you are using COUNTIFS, AND function is no longer needed. Can you try this -

```=COUNTIFS(
{Date}, >=DATE(2024,1,1),
{Date}, <=DATE(2024,1,31)
```

...

• ✭✭✭✭✭✭
Options

You can use the AND function to avoid having to repeat the {Range}. You just had some extra parenthesis and needed "@cell" references.

=COUNTIFS({Date}, AND(@cell >= DATE(2024,1,1), @cell <=DATE(2024,1,31)))

But since it looks like you are trying to pull everything for the entire year, you could also use

=COUNTIFS({Date}, IFERROR(YEAR(@cell), 0) = 2024)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!