Help with if Statements and Dates

Closed
Report
-
 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

Cheers
KK

1 reply

Try this in cell B2
=IF(TODAY()>=A2,700,"")

Best regards,
Trowa
1
Thank you

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

CCM 2821 users have said thank you to us this month