I am trying to count number of Months in a given range.
Using formula - =SUMPRODUCT(--(MONTH(INT($B$2:$BA$100))=8))
But it is re-calculating Aug 2017 data for Aug 2018 Month.
Attached sample sheet for reference.
I am trying to count number of Months in a given range.
Using formula - =SUMPRODUCT(--(MONTH(INT($B$2:$BA$100))=8))
But it is re-calculating Aug 2017 data for Aug 2018 Month.
Attached sample sheet for reference.
Hi Shabaz- Paste this in G10 and copy down:Please Login or Register to view this content.
PS- Suggest you use Phuocam's Post#3 formula. The one shown here would misread the last day of the month.
Last edited by leelnich; 02-22-2018 at 03:48 AM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
Try this:
=COUNTIFS($B$2:$B$101,">="&F10,$B$2:$B$101,"<"&EDATE(F10,1))
if B2 =8/31/2017 5:19:00 PM then the result is 1
Thanks alot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks