Feb 24 2020 02:36 PM
I am trying to figure out the points if the person start date is previous than 08-04-19, I want to leave them as blank or N/A automatically.
for example, ID# 31025 start date is 02-19-19, but I have data from 08-04-19. so I want this person's point leave as N/A or blank. I tried to use IF function but I don't know how.
Also, I am trying to figure out if the person start date + 30 days is bigger than the earliest date which is 02-16-20, I don't want to calculate those person because I don't have their all points yet.
Please help me how to figure out these problems.
Thank you so much!