Calculates number of days for certain quarter, starting from given quarter with offset number of quarters.
QuOffset = -1 to return 1 quarter back
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
' 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 91
Downloads 29
CodeID
DB ID
