LinkBack URL
About LinkBacks
MSE 
After checking again, try again:
=COUNTIFS($D$2:$O$9,"<"&EOMONTH("2016/12/31",COLUMNS($A:A)),$D$2:$O$9,">"&EOMONTH("2016/12/31",COLUMNS($A:A)-1)+1)
After checking again, try again:
=COUNTIFS($D$2:$O$9,"<"&EOMONTH("2016/12/31",COLUMNS($A:A)),$D$2:$O$9,">"&EOMONTH("2016/12/31",COLUMNS($A:A)-1)+1)
Quang PT
Thanks guys. The formula from bebo 021999 and davesexcel both work on my sample, but unfortunately I cannot figure out which
cells to adjust in my actual spreadsheet. Here is the actual one I'm using with the location info taken out. I DO want to count
dates in both "open" and "closed" sections
DaveUK, I meant that I didn't want to count the Start and End date columns.
Lost the attachment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks