Forum Discussion
Solved
If then formula with dates
Hi all, I need your help with my formula. I want to create a sheet on monthly payment collection with this formula: =IF(I14<"C2","Paid",IF(I14>"C2 ","Late Payment",IF(I14="","Not paid","Not paid")))...
Thank you. I'd change formula as
=IF( B8="", "Not paid", IF(B8 <=$C$2,"Paid", IF( B8>$C$2,"Late payment", "") ))In original formula =IF(B8<=$C$2,"Paid",IF(B8>$C$2,"Late payment",IF(B8="","Not paid",""))) first condition always works for any blank cell since it's always less than any date.
Is it possible to share the same within Excel file? It looks like you have texts which looks like dates, not dates which are actually numbers in Excel.
SergeiBaklan Yes, of course. Thank you so much!
Thank you. I'd change formula as
=IF( B8="", "Not paid", IF(B8 <=$C$2,"Paid", IF( B8>$C$2,"Late payment", "") ))In original formula =IF(B8<=$C$2,"Paid",IF(B8>$C$2,"Late payment",IF(B8="","Not paid",""))) first condition always works for any blank cell since it's always less than any date.
- Thank you so much. I really appreciate it. You're my saviour!
SyahiraH3199 , you are welcome