Help with if Statements and Dates

Closed
KK - Nov 30, 2009 at 05:49 AM
 Trowa - Nov 30, 2009 at 08:03 AM
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 response

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

Best regards,
Trowa
1