Forum Discussion
Solved
Calculate the points for irregular dates
Hi, I am trying to calculate the points from the hired date to 1st month, 2nd month, and 3rd month.
There is a row for the date with points for each person.
but the thing is the date with points are irregular.
How can I calculate the points range from hired date to 1st month points when the date is irregular?
Then I can just drag down and will automatically calculate for the rest people points.
Thank you
I calculated for first month, first two months, first three months. If second month (not first two)
=SUMIFS(I3:X3,$I$2:$X$2,"<="&EDATE($B3,2),$I$2:$X$2,">"&EDATE($B3,1))same for third
10 Replies
Do you have any rules as to what those dates may be?
For example, can the first, second or third month dates be weekend dates?
