This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello all! I am trying to find the correct formula to find the last day of the previous month. I am running a report that will calculate DSO and I need to multiply by the number of days in the previous month. Any help would be appreciated!
By number of days are you looking at business days or calendar days? If calendar, then we could use a formula and identify the day element of the last day of the prev. month calculation. Something like this:
Not sure I understand the question, sorry! Can you give us more context on how your data is structured, or give us a couple rows of anonymized data for us to play with and come up with a skeleton solution for you.
Each month I will have two columns....Total AR and Total Sales. I want to divide Total AR by Total Sales and then multiply by the number of days in the previous month. I created a column called DSO and that is where my formula will be. However, each month will have a different amount of days. I will always need the previous months number of days.