# COUNTING MTD ENTRIES

Options

I have been able to get YTD results with this formula:

=COUNTIFS({DATE SOLD}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))

However, I am unable to get a formula right for MTD. Any assistance would be much appreciated

Thanks,

Jason

• Options

Paul, you saved me again. Thanks so much.

• ✭✭✭✭✭✭
Options

Happy to help! 👍️

• Options

Paul, Is there a modification that can be made to these two formulas to display: YTD count of prior year and MTD count of prior year?

=COUNTIFS({DATE SOLD}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

=COUNTIFS({DATE SOLD}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), IFERROR(MONTH(@cell), 0) = MONTH(TODAY())))

• ✭✭✭✭✭✭
Options

Yes. We just subtract 1 from the year criteria in each of them

=COUNTIFS({DATE SOLD}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1)

=COUNTIFS({DATE SOLD}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1, IFERROR(MONTH(@cell), 0) = MONTH(TODAY())))

• Options

Thanks Paul. Unfortunately, the 1st formula counts all of 2019 entries rather than stopping at today's date and month of 2019

The second formula counts all April 2019 entries rather than stopping at today's date (4/9) of 2019

• Options

Awesome! Thanks again Paul!

• ✭✭✭✭✭✭
Options

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!