Search results

Okay, so it appears that Haseeb's formula brings back the #Div/0! error if there is a Traveler in the list that does not meet the specified criteria (ie. They don't have travel between the Start and End dates, or all of their travel has a cancelled status.)

Excellent! Thank you so much. The performance seems good so far, but I have not fully loaded a years worth of data just yet.

Thanks Faseeh. I like the approach, but the problem is first knowing all the individuals names that will appear in the data. I do not, as the names can change with each new run of the data. ** I mispoke. Your formula in column E does find the name of the traveler, but how far down would I...

I agree, but my project is building a dashboard with no pivots and no VBA, forumlas only. :(

=WEEKNUM(DATE(YEAR(TODAY()),12,31))-WEEKNUM(TODAY()) Although, you may want to exam how excel assigns the week numbers. For example, there are 53 weeks in some years.

Good morning all, I have an excel formula question that has been stumping me this morning. My data: A list of all employee travels for a one year period, including traveler name, travel departure date, whether the trip occurred or was cancelled (authorization status), and cost of travel. If...