Excel - IF Functions

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi ,

I made a forumlua that finds the difference between the date of one cell against todays date to get the total number of days that have gone past since they started. I need help making a if function that will flag YES if the total of days in the cell = either 1 or mutipules of three thereafter ie 1,4 ,7 ,10 ,13

Any help would be appericated

Thanks




1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can use

=IF(OR(A2="", A2<=0), "", IF(AND(A2>0, MOD(A2-1,3)=0), "YES", "No"))