Share via

Help with a formula

Anonymous
2022-10-01T08:28:11+00:00

=SUMIFS(LeaveTracker[Days],LeaveTracker[Employee Name],valSelEmployee,LeaveTracker[Date],">="&DATE(Calendar_Year,1,1),LeaveTracker[End Date],"<"&DATE(Calendar_Year+1,1,1),LeaveTracker[Type of Leave],'Leave Types'!B6)

I'm using this formula from an Excel Attendance tracker template. The template requires me to enter a start and end date for the calculation to show up on the calendar tab as and entry. I don't need the "end date" for my needs. I just want it to count the sum the days entered.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-10-01T09:30:52+00:00

    Thanks you so much @HansV

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2022-10-01T08:55:13+00:00

    If you don't need the start date and end date:

    =SUMIFS(LeaveTracker[Days],LeaveTracker[Employee Name],valSelEmployee,LeaveTracker[Type of Leave],'Leave Types'!B6)

    Was this answer helpful?

    0 comments