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
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 *
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
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks