Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-18-2018, 05:06 PM
esimmonds esimmonds is offline Revenue Recognition Schedule formula problem Windows 7 64bit Revenue Recognition Schedule formula problem Office 2016
Novice
Revenue Recognition Schedule formula problem
 
Join Date: May 2018
Posts: 2
esimmonds is on a distinguished road
Default Revenue Recognition Schedule formula problem

I need to create a revenue schedule:

Invoice
Created on date
Start date of service


End date of service
Amount

My problem is I am trying to add a variable to my current or create a new formula that would take into consideration the create on date of the invoice as sometimes the customer is invoiced late so the service start period may be before the created on date. This means that something with the service date starting in July could be billed for in Sept – so the Sept column should show 3 mths of service and then the other months would should 1 mth each until the end service date.

In addition, I am using 360 days not 365 days (see attached example) and I think for what I am trying to do that the year may need to be in the formula.
Attached Files
File Type: xlsx Book1.xlsx (23.0 KB, 22 views)

Last edited by macropod; 05-18-2018 at 05:10 PM. Reason: Split from: http://www.msofficeforums.com/excel/20176-excel-formula-showing-revenue-recognition-based-days.html
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing schedule into another schedule and keeping the links abby1428 Project 0 03-16-2018 04:21 PM
Deferred Revenue Amortisation Formula help Haha88 Excel 8 01-08-2018 02:00 PM
Revenue Recognition Schedule formula problem I am asking some formula for electrical panel schedule james64 Excel 2 01-16-2016 09:23 PM
Revenue Recognition Schedule formula problem Revenue REcognition for Leasing business sshetty Excel Programming 1 05-11-2015 01:42 AM
Excel Formula Showing Revenue Recognition Based on Days and Months stratcat Excel 4 03-16-2014 10:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft