Results 1 to 2 of 2

Semi Annual Dates

Threaded View

  1. #1
    Registered User
    Join Date
    07-19-2016
    Location
    Colorado
    MS-Off Ver
    Microsoft Office 15
    Posts
    22

    Semi Annual Dates

    I am trying to have excel return a Semi Annual date (my two dates are 1 April and 1 November) from a date in cell A1 but my current formula will not switch to the next year once I get to December. The year of my date only changes to my next Semi Annual date and year once I am in January of the next year.

    Example: Cell A1 Date: October 1, 2016 returns the correct Semi Annual date of November 1, 2016 based on the formula below:

    =IF(MONTH(A1)>4,DATE(YEAR(A1),11,1),DATE(YEAR(A1),4,1))

    Once the date is December 1, 2016 in cell A1 I would like it to return 1 April, 2017.

    Please let me know if you can help the formula works great except in December.
    Last edited by PsychicFish; 07-19-2016 at 10:41 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-07-2014, 06:19 PM
  2. Semi-annual issues
    By Sami Kaasalainen in forum Excel General
    Replies: 7
    Last Post: 11-26-2010, 12:02 PM
  3. Rounding to Semi-Annual Dates
    By Twisty20 in forum Excel General
    Replies: 2
    Last Post: 07-25-2007, 05:37 PM
  4. Semi Annual Counter
    By ExcelMonkey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-21-2006, 06:10 PM
  5. Number of semi-monthly periods between 2 dates
    By sforr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. [SOLVED] Number of semi-monthly periods between 2 dates
    By sforr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] Number of semi-monthly periods between 2 dates
    By sforr in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-15-2005, 11:05 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