Calculate the points for irregular dates

Copper Contributor

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!

 

0 Replies