Counting Criteria under the Date today Only

S

Shinianne

New Member
Joined
Aug 6, 2018
Messages
24
Office Version
  1. 365
24DWYHV


Great day,

I'd like to ask for you kind assistance
Will it be possible to count the VL that falls under the date today?

if yes can you kindly help please thank you so much:confused:




18-Mar19-Mar20-Mar21-Mar22-Mar23-Mar24-Mar
ScheduleRegionMondayTuesdayWednesdayThursdayFridaySaturdaySunday
11PM-8AMAMER11PM-8AM11PM-8AM11PM-8AM11PM-8AM11PM-8AMRDRD
11PM-8AMAMER11PM-8AM11PM-8AM11PM-8AM11PM-8AM11PM-8AMRDRD
11PM-8AMAMER11PM-8AM11PM-8AM11PM-8AMRDRD11PM-8AM11PM-8AM
11PM-8AMAMER11PM-8AM11PM-8AM11PM-8AMRDRD11PM-8AM11PM-8AM
11PM-8AMAMER11PM-8AM11PM-8AM11PM-8AM11PM-8AM11PM-8AMRDRD
11PM-8AMAMER11PM-8AM11PM-8AM11PM-8AMVL11PM-8AMRDRD
11PM-8AMAMER11PM-8AM11PM-8AM11PM-8AM11PM-8AM11PM-8AMRDRD
3PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
3PM-12AMEMEA3PM-12AM3PM-12AMRDRD3PM-12AM3PM-12AM3PM-12AM
3PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
3PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
3PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
3PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
Two options


Excel 2013/2016
ABCDEFGHIJK
118-Mar19-Mar20-Mar21-Mar22-Mar23-Mar24-Mar
2
3ScheduleRegionMondayTuesdayWednesdayThursdayFridaySaturdaySunday
411PM-8AMAMER11PM-8AM11PM-8AM11PM-8AM11PM-8AM11PM-8AMRDRD2
511PM-8AMAMER11PM-8AM11PM-8AM11PM-8AM11PM-8AMVLRDRD2
611PM-8AMAMER11PM-8AM11PM-8AMVLRDRD11PM-8AM11PM-8AM
711PM-8AMAMER11PM-8AM11PM-8AM11PM-8AMRDRD11PM-8AM11PM-8AM
811PM-8AMAMER11PM-8AM11PM-8AM11PM-8AM11PM-8AM11PM-8AMRDRD
911PM-8AMAMER11PM-8AM11PM-8AM11PM-8AMVL11PM-8AMVLRD
1011PM-8AMAMER11PM-8AM11PM-8AM11PM-8AMVL11PM-8AMRDRD
113PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
123PM-12AMEMEA3PM-12AM3PM-12AMRDRD3PM-12AM3PM-12AM3PM-12AM
133PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
143PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
153PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
163PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
Recon-I
Cell Formulas
RangeFormula
K4=COUNTIF(INDEX(C4:I16,0,MATCH(TODAY(),C1:I1,0)),"VL")
K5=SUMPRODUCT((C4:I16="VL")*(C1:I1=TODAY()))
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
IF with OR and Today Functionality
Replies
1
Views
635
Panda514
P
W
  • Locked
  • Question
Counting Dates in weeks per Month
Replies
1
Views
249
Peter_SSs
Peter_SSs
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
486
AndyEd
A
A
  • Solved
Calendar issue
Replies
1
Views
1K
AndyEd
A
L
  • Question
VBA works on work PC but not home PC
Replies
3
Views
2K
rollis13
rollis13

Forum statistics

Threads
1,215,851
Messages
6,127,296
Members
449,374
Latest member
analystvar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top