The formula takes the difference of two dates and adds it up in the start date to get all the dates in the range. Then it uses TEXT() function to format it as first three letters of the day and then perform match and sum the count.
Category: Math and trigonometry
Adds its arguments
Formats a number and converts it to text
TEXT(Value you want to format, “Format you want to apply to that value”)
Category: Lookup and reference
Returns the row number of a reference
Returns a reference indicated by a text value
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM