Hi,
I try to find out how to make sumifs formula in vacation tracker when the end date of vacation is in another month. When start date is 11.01.2014. and end date is 03.03.2014 and I want to calculate how many days employee was on vacation just in january. Because vacation starts in current month and it ends on next month formula return no value =SUMIFS(Vacations['# of days taken];Vacations[Start Date];">="&B12;Vacations[End Date];"<="&EOMONTH(B12;0);Vacations[Vacation Code];"<>"&3) . In cell B12 is 01.01.2014. How to fix that?
I attach file so you can see my problem.
Thanks,
Maja
I try to find out how to make sumifs formula in vacation tracker when the end date of vacation is in another month. When start date is 11.01.2014. and end date is 03.03.2014 and I want to calculate how many days employee was on vacation just in january. Because vacation starts in current month and it ends on next month formula return no value =SUMIFS(Vacations['# of days taken];Vacations[Start Date];">="&B12;Vacations[End Date];"<="&EOMONTH(B12;0);Vacations[Vacation Code];"<>"&3) . In cell B12 is 01.01.2014. How to fix that?
I attach file so you can see my problem.
Thanks,
Maja