My question is a simple thought process but more complicated on the spreadsheet. All I need to do is produce an aging accounts receivable for loans and funding dates. For example:
Date Sold Date Submitted Date Funded Age
The final column would be the subtraction from Date Sold to Date Funded. However, if there are any blanks in the date columns I get and error in the Age column. My instincts tell me to use SUMIF, but that is as far as I get. Any help would be greatly appreciated.
Thank you!
Newbie/rookie
Bookmarks