+ Reply to Thread
Results 1 to 4 of 4

Formula to calculate the percentage of a year using a start date and year to date dates

  1. #1
    Registered User
    Join Date
    08-14-2012
    Location
    Dunedin, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    7

    Formula to calculate the percentage of a year using a start date and year to date dates

    I really need help on this one I have been trying for ages and can't work it out.

    the problem is start of year date is 1 April 2012 and the year to date figure is 27 August 2012 I need a formula to calculate the percentage of the year

    Thanking you for your help

    Pam

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

    Re: Formula to calculate the percentage of a year using a start date and year to date date

    How about..

    =(A2-A1)/365 and format as %

    where A1 is start date and A2 is end date
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Formula to calculate the percentage of a year using a start date and year to date date

    How accurate do you want to be? This formula will take into account leap years and will work for any date in any year (assuming that the year start is 1st April in every year)

    =(A2-DATE(YEAR(A2+275)-1,4,1)+1)/SUM(DATE(YEAR(A2+275)-{0,1},4,1)*{1,-1})

    assumes 27 Aug 2012 or whatever is in A2
    Audere est facere

  4. #4
    Registered User
    Join Date
    08-14-2012
    Location
    Dunedin, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Formula to calculate the percentage of a year using a start date and year to date date

    Thanks I am really new to excel and struggling with formula's

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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