Results 1 to 2 of 2

Thread: Formula for changing calendar date into fiscal weeks
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula for changing calendar date into fiscal weeks

    Hi all!

    This is my first time post. Normally read other's post to help my problems, but I am having trouble this time.

    My fiscal year began on Sunday 27, 2017, and has 52 fiscal weeks, and can't figure out this week formula.

    I have 46,000 lines of data all with different dates. If a date is between Sept 17, 2017 thru Oct 2, 2017 then I need to spit out week 1, and so on and so forth.

    Can any help me with the formula?

    Thanks!

  2. #2
    MrExcel MVP
    Moderator
    barry houdini's Avatar
    Join Date
    Mar 2005
    Location
    England
    Posts
    20,825
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula for changing calendar date into fiscal weeks

    Hello, welcome to MrExcel

    If it’s just for this year then you can use this formula

    =INT((A2-DATE(2017,9,17))/7

    where date is in A2 - format result cell as number with zero decimal places.

    If if you want a formula for any year then that’s possible if you have a fixed rule for when year starts
    Last edited by barry houdini; Nov 9th, 2017 at 12:32 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •