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 calendar dates vs... TODAY() and text in the posting column. I've tried plugging in different formats and get 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 Thursday, September 25, 2014 VAC Friday, September 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 this:

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

or

=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.