Hi all,
I have a large dataset with the due dates stated in the way you can see in the attachment. I would like to get an overview if the due date is before the current date [TODAY()]. However, as you can see the formula is not working as AY2 needs to be "PAID".
Could you please help me? Thanks a lot!
Marissa
I have a large dataset with the due dates stated in the way you can see in the attachment. I would like to get an overview if the due date is before the current date [TODAY()]. However, as you can see the formula is not working as AY2 needs to be "PAID".
Could you please help me? Thanks a lot!
Marissa