Here is what I have:
=SUMPRODUCT(--(TEXT(DATE(YEAR(N(OFFSET(H49:BG49,0,{0,1,4,7,11,15,16,20,24,25,29,33,34,38,42,43,47,51},1,1))),
MONTH(N(OFFSET(H49:BG49,0,{0,1,4,7,11,15,16,20,24,25,29,33,34,38,42,43,47,51},1,1))),1),"yymm")=T EXT(TODAY(),"yymm")))
Basically this sums all dates that fall this month across a bunch of cells. How can I change this to sum all dates falling next month?
Change:
=SUMPRODUCT(--(TEXT(DATE(YEAR(N(OFFSET(H49:BG49,0,{0,1,4,7,11,15 ,16,20,24,25,29,33,34,38,42,43,47,51},1,1))),
MONTH(N(OFFSET(H49:BG49,0,{0,1,4,7,11,15,16,20,24, 25,29,33,34,38,42,43,47,51},1,1))),1),"yymm")=TEXT(TODAY(),"yymm")))
To:
=SUMPRODUCT(--(TEXT(DATE(YEAR(N(OFFSET(H49:BG49,0,{0,1,4,7,11,15 ,16,20,24,25,29,33,34,38,42,43,47,51},1,1))),
MONTH(N(OFFSET(H49:BG49,0,{0,1,4,7,11,15,16,20,24, 25,29,33,34,38,42,43,47,51},1,1))),1),"yymm")=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1,"yymm")))
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks