Below is a possible solution to the challenge – Challenge 45 – Number of Days Passed in a Quarter
The formula to calculate number of days passed in a quarter is
=A1-DATE(YEAR(A1),(ROUNDUP(MONTH(A1)/3,0)-1)*3+1,1)
Below is a possible solution to the challenge – Challenge 45 – Number of Days Passed in a Quarter
The formula to calculate number of days passed in a quarter is
=A1-DATE(YEAR(A1),(ROUNDUP(MONTH(A1)/3,0)-1)*3+1,1)