• JUser: :_load: Unable to load user with ID: 42

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.

See the Youtube video on “Excel Q&A: Split Account Codes into Separate Columns” below:

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.