Weeks Starting Thursday

    Hello again everyone.


    I was wondering if anyone could help me with a problem I'm having.


    I have data that I would like to sort out in terms of yesterday, last month, this week, last week, last week-1 & last week -2.


    The problem I'm having is that I need to start my weeks from a Friday. So the "last week" tab would need the last Friday to the current date. Then the week before would have to be the previous friday to last thursday, etc.


    I'm trying to incorporate as much of the autofilters as I can but I'm really having difficulty with it.


    Anyone got any possible suggestions or able to even just point me in the right direction?


    Many thanks


    :)

    Re: Weeks Starting Thursday


    Last Friday's date is:


    =TODAY()-WEEKDAY(TODAY()-7,16)


    To get the week before, just subtract 7, and so forth.

    Jeff


    Making the world a better place one fret at a time | | |·| |·| |·| |·| | |:| | |·| |·|

    Re: Weeks Starting Thursday


    This was perfect! Thankyou!


    EDIT


    Actually after adding the 16 at the end I couldn't get it to work.


    Any ideas? I've been playing around with it but no luck :s


    Thankyou :)

    Re: Weeks Starting Thursday


    The 16 is to indicate the option of what day of the week will return 1, and so forth. What version of Excel do you have?

    Jeff


    Making the world a better place one fret at a time | | |·| |·| |·| |·| | |:| | |·| |·|

    Re: Weeks Starting Thursday


    Sorry, I did get it working! Thankyou! I was being dozey and putting it into a cell as opposed to the vba code!!! Hahaha


    Works like a charm! :spin:

    Re: Weeks Starting Thursday


    Glad it worked, but the formula I provided was intended to be put into a cell! :confused:

    Jeff


    Making the world a better place one fret at a time | | |·| |·| |·| |·| | |:| | |·| |·|

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login