Snasui Excel Forum

Hi Dear
Say hello to all expert here
I need your help to track Past due for Motor rent.
For example
Mr A request to rent motor for 3 months due to his wrong condition.
His request on 01/04/2020
I want to show alert when due
In A1 I input Date :01/04/2020
In B1 I input 3
In C1 I want to show it is < Due> when it is come due otherwise not showing means nothing

Hope you may help

Best wishes,

Could you please attach example file for easy to understand your querstion?

Hi Dear
Here's an example file


Best wishes,

Try this,

C2

=IF(TODAY()>EDATE(A2,B2),"Due","")

Press enter.