-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
invoice dates
-
H
Losing my mind over this. Is my assignment incorrect or do I just not know what I'm doing? (regarding utility invoices & calendarizing data)
I need to calculate the total # of calls, texts, & emails facilitated on a company's network each month from Jan 16 - Jan 17. The issue: the data set given to me only contains Summary invoices, which show total volumes grouped by the type of usage over each individual invoice term. Since...- helnuma2k
- Thread
- calendarization calendarize invoice invoice dates invoice summary sheet utility
- Replies: 12
- Forum: Excel Questions
-
H
Pull invoice data-entry into annual budget sheet to show YTD spend per budget line, per month?
Hi, My first tab shows my annual budget plan, for about 130 budget lines (rows). One annual total per budget line. In my second tab, I enter invoice data (all payables) throughout the year, i.e. I'm constantly adding new rows and entering newly-received invoices. As I do this, one of the cells...- hfulton
- Thread
- budget invoice dates invoice line items invoice tracking tab
- Replies: 2
- Forum: Excel Questions
-
O
Formula for adding interest to a figure for each 30 days
Hi there, I am looking for a formula to help speed up a process. I have a spreadsheet which details invoice values and I need add 2% interest on for each 30 days that the invoice is overdue. I have columns titled; invoice number, invoice date, invoice due date (30 days from date), invoice...- olimajor123
- Thread
- interest invoice dates
- Replies: 0
- Forum: Excel Questions
