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

1. ## 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

Pam

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

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

where A1 is start date and A2 is end date

3. ## 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

4. ## 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

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

#### 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