D
djeans
Hello,
I am trying to figure out how to determine the week number of th
current period based on a given date.
I found a thread on here about determining period number that ha
worked well:
=MONTH(EOMONTH(A1,0))
Which returns the current period (7 - our periods start in January
but, I would like a formula that would return "Period 7 - Week 4" fo
instance.
Any help would be greatly appreciated.
Darron Jean
I am trying to figure out how to determine the week number of th
current period based on a given date.
I found a thread on here about determining period number that ha
worked well:
=MONTH(EOMONTH(A1,0))
Which returns the current period (7 - our periods start in January
but, I would like a formula that would return "Period 7 - Week 4" fo
instance.
Any help would be greatly appreciated.
Darron Jean