countif based on certain month due date

**johan58** · 03-19-2024, 09:42 AM

hello,

i have a table contains customers that has 4 items. every items has its own due date.
how to count how many items that has due date on march 2024?

thanks before

Simulation 4.xlsx

simulation 4.PNG

**Fluff13** · 03-19-2024, 09:52 AM

How about

Formula:

Please Login or Register  to view this content.

**windknife** · 03-19-2024, 09:52 AM

Try this in G2 and copy down.

Please Login or Register  to view this content.

PS. D3's date wrong, it should be 2024/3/30

**johan58** · 03-19-2024, 10:02 AM

Originally Posted by Fluff13

How about

Formula:

Please Login or Register  to view this content.

amazing thank you

**johan58** · 03-19-2024, 10:03 AM

Originally Posted by windknife

Try this in G2 and copy down.

Please Login or Register  to view this content.

PS. D3's date wrong, it should be 2024/3/30

yes im sorry, it should be in 2024.
amazing function thank you very much

**windknife** · 03-19-2024, 10:07 AM

You are welcome.

**Fluff13** · 03-19-2024, 10:15 AM

Glad to help & thanks for the feedback

countif based on certain month due date

LinkBack

Thread Tools

Rate This Thread

Display

countif based on certain month due date

Re: countif based on certain month due date

Re: countif based on certain month due date

Re: countif based on certain month due date

Re: countif based on certain month due date

Re: countif based on certain month due date

Re: countif based on certain month due date

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Countif Formula for Month and Date

COUNTIF formula if date is within certain month

Help with COUNTIF date is in specified month/year but date column has blank cells

[SOLVED] Countif based on month

Countif Date less than 3 months from another Date AND another column=certain month

[SOLVED] countif based on month

CountIf by Month-to-date

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions