When the DAYS360() can’t solve it, use this…

Today, we take a look at something we’ve been asked several times….does the DAYS360() count the days after 24 Hours. Philip teaches in this video how to fix the problem when you really mean >=24hrs is 1 day.

Want to get text into meaning full components?

In today’s Excel Q&A, Philip Gamey shows how to use RIGHT, LEFT and MID functions to get an account code into meaningful components.

One way is to sort from largest to smallest and write numbers by each another is to use RANK FX

This Excel Q&A shows how to use the RANK function to rank customers by their revenue.