Forum Discussion
Calculate the points for irregular dates
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
Oh yeah the first month is correct but I calculated the same ID person for the second month points but it should be 5 points which should not include the first month points. so 2nd month points should be from 1/10-2/10. and 3rd month is same
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
Is it possible to calculate if the person start date is previous than the date which is 08-04-19, can I leave them as a blank or N/A?
for example, ID# 31025 start date is 02-19-19 and there is no data at that time because there is no data before 08-04-19. I want to leave them as a blank or N/A. Is it possible?
Thank you so much!