End Date (if there is one, otherwise calculate on the entire holiday year_
No of Holidays
Holiday year runs from 01/04 to 31/03 with an entitlement of 20 days plus bank holidays
any help is much appreciated
When there are two lists in your worksheet as right screenshot shown, one is the list of dates, the other is the list of the values. And you want to sum up the values between two dates range only, for instance, sum up the values between 3/4/2014 and 5/10/2014, how can you calculate them quickly? Now, I introduce a formula for you to sum up them in Excel.
Fortunately, there is a formula can sum up the values between two dates range in Excel.
Select a blank cell and type into this formula =SUMIFS(B2:B8,A2:A8,">="&E2,A2:A8,"<="&E3), and press Enter button. And now you will get the calculating result. See screenshot:
Note: In above formula, B2:B8 is the value list you will sum up, A2:A8 is the date list you will sum based on, E2 is the cell with start date, E3 is the cell with end date, and you can change them based on your needs.
|Formula is too complicated to remember? Save the formula as an Auto Text entry for reusing with only one click in future!
Read more… Free trial
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
300 New Features for Excel, Make Excel Much Easy and Powerful: