Formula for cells with different data types I\'m putting together an Excel sheet

Question

Formula for cells with different data types I'm putting together an Excel sheet to track vacation scheduling for an office. I'd like to track days posted, used, remaining to post. I'm stuck trying to use caleendar dates vs. TODAY() and text in the posting column. I've tried plugging in different formats and geet the same error for this part of the formula for days used. =COUNTIF(B8:B20,"=VAC")*(A8:A20<=TODAY()). Assistance please. Tks. DAYS AVAILABLE 15 DAYS SCHEDULED 4 DAYS USED #VALUE! DAYS REMAINING #VALUE! NAME JOHN DOE Monday, September 29, 2014 DATE Thurssday, September 25, 2014 VAC Friday, Septembeer 26, 2014 VAC Saturday, September 27, 2014 VAC Sunday, September 28, 2014 Monday, September 29, 2014 Tuesday, September 30, 2014 Wednesday, October 1, 2014 VAC

Explanation / Answer

Hi,

Try thiis

=SUMPRODUCT(($B$8:$B$20="VAC")*($A$8:$A$20<=TODAY()))

orr

=COUNTIFS($B$8:$B$20,"VAC",$A$8:$A$20,"<="&TODAY())

Hope this helps....

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.