Fiscal Year Week Number Calculation with a twist....
in [Programming]
|
Prev: Get cell value
Next: open from sharepoint
From: Rick Rothstein on 31 Mar 2010 14:23 Hmm, I don't see any posting in this thread by "Gary Brown"... am I the only one not seeing that response? -- Rick (MVP - Excel) "George" <George(a)discussions.microsoft.com> wrote in message news:E299A1EB-1F89-428D-9076-4A21C82CA3AE(a)microsoft.com... > Gary, Thank You .....Works Perfect.. > > "Gary Brown" wrote: > >> Assuming the 'Start' year is in Cell A1 and the date you want to check is >> in >> A2... >> =ROUNDUP(((A2-MOD(A2-2,7)-DATE($A$1,4,1))/7)+1,0) >> >> So... >> Cell A1 = 2010 >> Cell A2 = 04/01/2010 >> The formula above will return a '1' >> >> -- >> Hope this helps. >> If it does, please click the Yes button. >> Thanks in advance for your feedback. >> Gary Brown >> >> >> >> "George" wrote: >> >> > Good Day, >> > >> > I've search for the solution to this including Cpearson's site but >> > can't >> > figure this out..Our Fiscal year begins April 1st every year regardless >> > of >> > the day of the week it falls on. So here's my delima, if it falls on >> > any day >> > other than a Monday I need to be able to recognize a short week as week >> > 1 >> > ending on Sunday and week 2 beginning on the 1st Monday after and each >> > week >> > following run Monday - Sunday. >> > >> > Example for this year >> > >> > Thurs,4-1-2010 thru Sun 4-4-2010 = Week 1 >> > Mon,4-5-2010 thru Sunday,4-11-2010 = Week 2 >> > and so on >> > >> > Thank you in advance for taking time to look at my issue. >> > Respectfully, >> > George
From: Bob Phillips on 31 Mar 2010 15:36
Nope, I don't see it either. This seems to happen a lot, I often see a guy thanking a response when I gave the self same response hours earlier. It seems to be something to do with the Microsoft web forum. -- HTH Bob "Rick Rothstein" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote in message news:e%23R$98P0KHA.3412(a)TK2MSFTNGP05.phx.gbl... > Hmm, I don't see any posting in this thread by "Gary Brown"... am I the > only one not seeing that response? > > -- > Rick (MVP - Excel) > > > > "George" <George(a)discussions.microsoft.com> wrote in message > news:E299A1EB-1F89-428D-9076-4A21C82CA3AE(a)microsoft.com... >> Gary, Thank You .....Works Perfect.. >> >> "Gary Brown" wrote: >> >>> Assuming the 'Start' year is in Cell A1 and the date you want to check >>> is in >>> A2... >>> =ROUNDUP(((A2-MOD(A2-2,7)-DATE($A$1,4,1))/7)+1,0) >>> >>> So... >>> Cell A1 = 2010 >>> Cell A2 = 04/01/2010 >>> The formula above will return a '1' >>> >>> -- >>> Hope this helps. >>> If it does, please click the Yes button. >>> Thanks in advance for your feedback. >>> Gary Brown >>> >>> >>> >>> "George" wrote: >>> >>> > Good Day, >>> > >>> > I've search for the solution to this including Cpearson's site but >>> > can't >>> > figure this out..Our Fiscal year begins April 1st every year >>> > regardless of >>> > the day of the week it falls on. So here's my delima, if it falls on >>> > any day >>> > other than a Monday I need to be able to recognize a short week as >>> > week 1 >>> > ending on Sunday and week 2 beginning on the 1st Monday after and each >>> > week >>> > following run Monday - Sunday. >>> > >>> > Example for this year >>> > >>> > Thurs,4-1-2010 thru Sun 4-4-2010 = Week 1 >>> > Mon,4-5-2010 thru Sunday,4-11-2010 = Week 2 >>> > and so on >>> > >>> > Thank you in advance for taking time to look at my issue. >>> > Respectfully, >>> > George > |