Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
could some one help me correcting the function
Am trying to get the number of weeks in a Quarter, for that I have subtracted first week of quarter and last week of quarter
week(QuarterStart(today())) is giving me 40 (which is expected)
week(QuarterEnd(today())) is giving me 1 (it should actually give me 53)
could some one help me in this.
thanks
Try this:
=week(QuarterEnd(today()),6,1)
Parameter Six is to identify which is the first day of the week. 6=Sunday.
Add another parameter to have broken weeks applied to week function.
For more info, refer to
Thanks and regards,
Arthur Fong
Try this:
=week(QuarterEnd(today()),6,1)
Parameter Six is to identify which is the first day of the week. 6=Sunday.
Add another parameter to have broken weeks applied to week function.
For more info, refer to
Thanks and regards,
Arthur Fong