+ Reply to Thread
Results 1 to 2 of 2

Need help with Calendar formula for previous year and next year

  1. #1
    Registered User
    Join Date
    11-06-2003
    MS-Off Ver
    2013
    Posts
    75

    Need help with Calendar formula for previous year and next year

    I found an Excel template that gives me a calendar year based on the number that I put into cell A4. This will then populate the 12 months with the correct dates in the correct day. However, I can not figure out how to get the month of December for the previous year and the month of January for the following year to work. Can someone help me figure out why the additional two months only give me blank days? I am using Excel 2010 version and I have attached the spreadsheet. I thought that if I used the same formula set up in the main calendar that all I would need to do is change the location of the reference year from A4 to A34 or A35, but it is not working. I am stumped on this one. Maybe overthinking it.
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Need help with Calendar formula for previous year and next year

    I added two defined name ranges viz. DecSun2 and JanSun2 and changed the formulas for these two months

    You don't need to the years in Cell A34 and A35

    See attached
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    11-06-2003
    MS-Off Ver
    2013
    Posts
    75

    Re: Need help with Calendar formula for previous year and next year

    Thanks for the solution. That worked, but I did find that I needed the dates in cells A34 and A35 for the additional two months to work. If I removed the years in those cells, then the "calendar month" goes blank again. I even tried to change the formula to look at A4 but again, I get blanks. However, your solution does work and I am ok with having the other two years. Thanks for your quick response.

+ 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. Transpose Quarters from Calendar Year to Fiscal Year
    By jodiander in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2013, 01:00 PM
  2. Input a year to determine the start date for 4-4-5 Calendar Year.
    By mak1176 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-25-2013, 10:34 AM
  3. [SOLVED] Keeping a date as current year, even though formula determines previous year
    By dropanddrive03 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-28-2013, 08:31 PM
  4. Determine if date is before end of fiscal year of previous year
    By ccarver in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2010, 11:53 AM
  5. [SOLVED] change the year in a calendar template to different year
    By George in forum Excel General
    Replies: 1
    Last Post: 07-19-2006, 02:34 PM

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