Hi,
I am trying to count the number of dates that occur within a date - between the start date of a week and the end date of a week.
Please see attached sheet.
Hi,
I am trying to count the number of dates that occur within a date - between the start date of a week and the end date of a week.
Please see attached sheet.
Try this in H4
=COUNTIFS($A$2:$A$23,">="&F4,$A$2:$A$23,"<="&G4)
For 2003 and earlier versions
=SUMPRODUCT(($A$2:$A$23>=F4)*($A$2:$A$23<=G4))
Although I see you've attached a xlsx file which means you have later version
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi forgot to add a column alongside the dates list every other date should have the word induction next to it and only the dates with induction next to them need to be counted.
Use
=COUNTIFS($A$2:$A$23,">="&F4,$A$2:$A$23,"<="&G4,$B$2:$B$23,"Induction")
or
=SUMPRODUCT(($A$2:$A$23>=F4)*($A$2:$A$23<=G4)*($B$2:$B$23="Induction"))
Fnatastic Thank You - where is the * to say thanks BTW?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks