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 traack vacation scheduliing for an office. I'd like to track daays posted, used, remaining to ppost. I'm stuck trying to use calendar dates vs. TODAY() and text iin 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, Septemmber 28, 2014 Monday, September 29, 2014 Tuesday, September 30, 2014 Wednesday, October 1, 2014 VAC

Explanation / Answer

Hi,,,

Try thiss

=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

---