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:




[TABLE="width: 613"]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]18-Mar[/TD]
[TD]19-Mar[/TD]
[TD]20-Mar[/TD]
[TD]21-Mar[/TD]
[TD]22-Mar[/TD]
[TD]23-Mar[/TD]
[TD]24-Mar[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Schedule[/TD]
[TD]Region[/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[TD]Friday[/TD]
[TD]Saturday[/TD]
[TD]Sunday[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]VL[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[/TABLE]
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
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 Question
IF with OR and Today Functionality
Replies
1
Views
695
Panda514
P
W
  • Locked
  • Question Question
Counting Dates in weeks per Month
Replies
1
Views
401
Peter_SSs
Peter_SSs
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
1K
AndyEd
A
A
  • Solved
Calendar issue
Replies
1
Views
2K
AndyEd
A
L
  • Question Question
VBA works on work PC but not home PC
Replies
3
Views
2K
rollis13
rollis13

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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