Help with if Statements and Dates

 Trowa -
Hi there,

I'd like to create a formula for a tenant ledger.

I'd like the tenant ledger to only display the rental amounts due on or after the date they are due

Where the Due date is in Cell A2, and the Due amount (700) is populated in cell B2 only when today is greater than or equal to A2 (I'm using a mac). if today is less then A2, I'd like B2 to be populated with nothing or at worst: '0'

I will be very grateful for the solution to my challenge, please, and thank you


1 reply

Try this in cell B2

Best regards,
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month