Today + 30 Days

Hello all. I've been combing through the forums a lot today and I've found similar topics...but I still just can't get this formula to function the way I need it to.

I need for Cell G3 to formulate the number of dates within Cell Range G8:G500 that will expire within 30 days of the current date.

I was trying "COUNTIF(G8:G500,"<"&TODAY()+30)" but to no avail. I've tried a few versions of this formula but...nope.

I don't know if this is contributing to the problem or not but there is some Conditional Formatting in Column G that highlights dates that are past "NOW" (Red Highlight) and dates that are due to expire within 30 days (Yellow Highlight).

Any assistance would be greatly appreciated!

Thanks!

Try


=COUNTIFS($G$8:$G4501,">="&TODAY(),$G$8:$G4501,"<"&TODAY()+30)

Dates >= Today and <= Today+30

That did it! Thank you, John! Man...I was tearing my hair out. Thank you, thank you, thank you!

Thanks for your reply loginjmor! I tried it but it didn't work. That extra dash by the date was just a typo as I quickly switched the actual data so I could post it online. Nice catch though! Thank you so much!

Really? It worked on the first try. I tested it with dates before, during and after the time-frame set and it functioned perfectly. Think I should try this other formula instead?

Yes ..... Senior moment!!! It's OK. Apologies for the confusion.

haha! :o) At least you know what you're doing! I've been with this thing for a few hours now. Ugh.

Absolutely! If you can guys can take the time to help a stranger, I can take the time to thank you for it! Cheers!

My thanks too for the rep but I think I'll quit now (today) while I am ahead!

So very welcome, good sir! Thanks again all...have a great weekend. I have a feeling I'll be posting more questions soon...working on a lot of Excel projects at work. They think I know more than I really do. :P