Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with offset number of quarters.
QuOffset = -1 to return 1 quarter back

CodeFunctionName
What is this?

Public

Tested

Original Work
Function Q_NoOfdays(Q_End_Date, Optional QuOffset = 0)
    ' Calculates number of days for certain quarter
    ' QuOffset = -1 to return 1 quarter back
    '
    CQD = CDate(Q_End_Date)
    Q_NoOfdays = DateAdd("M", (3 * (QuOffset + 1)), CQD) - DateAdd("M", (3 * QuOffset), CQD)
End Function

Q_End_Date, Optional QuOffset = 0

Views 64

Downloads 26

CodeID
DB ID

ANmarAmdeen
626
Attachments
Revisions

v1.0

Monday
June
10
2024