Hello, I am wondering whether there is a formula I can use for my issue. I want to calculate how many days an invoice has been outstanding, but not all invoices have been paid. I have a date issues column and a date paid column, then a days outstanding column. I have a formula for "Date paid" minus "Date issued" for work out the days a paid invoice was outstanding, and a separate invoice of "Today" minus "Date issued" for invoices that are still outstanding. Is there any way to combine these, I am thinking something like =IF(date issued column contains a value, "date paid" minus "date issued", otherwise "today" minus "date issued"). Is that possible? Hope that makes sense!
Moderator note:
Please read our forum rule #1 regarding proper thread titles.
Since you are new to the forum I went ahead and changed it for you this time. --- FlameRetired
Bookmarks