+ Reply to Thread
Results 1 to 2 of 2

Calculate Start & End Date & Month for Each Week In Fiscal Year

  1. #1
    Registered User
    Join Date
    09-06-2013
    Location
    Portland Oregon
    MS-Off Ver
    Excel 2010
    Posts
    23

    Calculate Start & End Date & Month for Each Week In Fiscal Year

    Looking for formulas that can calculate the start and end dates for each week in a fiscal year as well as the month that the week is in - with the fiscal year starting always on July 1st.

    So cell A1 would be starting date 7/1/2014.

    cell A3 would have a value of 1 for week #1.
    cell B3 would have a value of 2 for week #2.
    cell C3 would have a value of 3 for week #3.


    cell A4 would have the month for week #1 (so July)
    cell A5 would contain the calculate starting value of July 1 (Tuesday)
    cell A6 would contain the calculate ending value of July 5 (Saturday)

    cell B4 would have the month for week #2 (still July)
    cell B5 would contain the calculate starting value of July 6 (Sunday)
    cell B6 would contain the calculate ending value of July 12 (Saturday)

    cell C4 would have the month for week #3 (still July)
    cell C5 would contain the calculate starting value of July 13 (Sunday)
    cell C6 would contain the calculate ending value of July 19 (Saturday)

    and so on.

    And I would want the flexibility to change the starting and ending values of each week to start/end on different days such as:

    * Always Sunday and Saturday
    * Always Monday and Friday

    etc.

    Thanks

  2. #2
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Calculate Start & End Date & Month for Each Week In Fiscal Year

    Did you check excel templates for calendars ?

    http://office.microsoft.com/en-us/templates
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate week number for Fiscal Year Dates
    By katie_10042 in forum Excel General
    Replies: 16
    Last Post: 02-14-2017, 05:58 AM
  2. [SOLVED] Calculate US Government Fiscal Year Week with Sunday(Start) and Saturday (End)
    By CHRISTINA1234 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-23-2013, 06:13 AM
  3. how to convert date to fiscal year if fiscal year start at 16th or 17th of July
    By sushil shakya in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2013, 03:32 AM
  4. [SOLVED] Create Fiscal Year - Lookup Date in Fiscal Month Date Range and Return EOM Date
    By gbriscoe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-25-2013, 03:29 PM
  5. Replies: 4
    Last Post: 09-22-2005, 10:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1