F faiqmahdi New Member Oct 3, 2023 #1 Hi I want to know the Excel Formula which I can use to calculate Overdue Days. e.g. Invoice Date = 31 July 2023 Credit Allow = 30 Days Today's Date = 3 October 2023 Overdue Days = 34 Days Final Result Required 34 Days The image is attached for reference. Regards Attachments Overdue.png 22.3 KB · Views: 3
Hi I want to know the Excel Formula which I can use to calculate Overdue Days. e.g. Invoice Date = 31 July 2023 Credit Allow = 30 Days Today's Date = 3 October 2023 Overdue Days = 34 Days Final Result Required 34 Days The image is attached for reference. Regards
F faiqmahdi New Member Oct 3, 2023 #2 Hi Team I found the answer =DATEDIF([@[Invoice Date]],TODAY()-30,"D") to appear Days with the numeric number, I went to Format Cells, Custom, selected 0 "Days" Hope this will help for someone or any suggestion to improve is welcome.
Hi Team I found the answer =DATEDIF([@[Invoice Date]],TODAY()-30,"D") to appear Days with the numeric number, I went to Format Cells, Custom, selected 0 "Days" Hope this will help for someone or any suggestion to improve is welcome.
F faiqmahdi New Member Oct 3, 2023 #3 I just found that after Format Cells, Custom, selected 0 "Days" the Excel File got corrupted.
