COUNTIF formulas with dates (<>) in reference to =TODAY()

[CantExcel]

Hi Everyone,

Very new and inexperienced at Excel ---^ Hence the name!! Everything that I have tried to do before was very elementary and simple, like a budget.

I am trying to make an excel sheet for work and I need to count the dates as in greater than, overdue, and less than 1 month away. I have =NOW() in C1 for my reference.

What I need to do is count the dates from column K. (K16:K215)
I have 3 COUNTIF functions that I need to fulfill.
-#1: Dates within an interval. As long as that is Less Than (<) today's date that is fine.
-#2: Dates coming due <1 month from today's (C1) date
-#3: Dates overdue that are greater than (>) today's (C1) date.

Thanks a lot for reading and posting if you do. I really appreciate the help, my boss will think I am a genius if I can figure this out, hahahaha!!!

Have a great day!

 

[hemesh]

Hello, Welcome to the forum, You need to create two cell for this formula to be dynamic. One for today's date, Other for dates less than or Equal to 1 month from today's date
Assuming you are creating the same in A1 and B1.
Step 1. In A1 type =Today() and in B1 Type =date(year(A1),Month(A1)-1,Day(A1) hit enter
Step 2. Select the cell where you want to count the date that is less than today type =countif($K$16:$K$215,"<"&A1)
Step 3. Select the cell where you want to count less than a month dates(your second criteria) type =Countif($K$16:$K215$,"=>"$b$1)-countif($K$16:$K215$,"<="$A$1)
Step 4. select the cell where you want to count >today criteria type = countif($K$16:$K215$,">"$A$1)
Regards

 

[CantExcel]

Hemesh,

Thank you for the assistance!!

I was able to get Step 1. to work but i am having an issue with step 2 and 3. the $K215$ shows an error and get highlighted in the text box up top.

I attempted to upload a photo.

If you see the photo i had to change a1 ->D1 and B1->E1