+ Reply to Thread
Results 1 to 1 of 1

Using Days360 for subscription calculation

  1. #1
    Registered User
    Join Date
    04-12-2013
    Location
    New York, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Using Days360 for subscription calculation

    I've calculated deferred revenue and monthly revenue calculations for subscription revenue in the attached spreadsheet. The calculation is driven based on the days to the next invoice date. It works well aside from one problem. An invoice can be sent on any day of the month and it is only valid for that month (or 12 months if a year invoice). The issues comes from the change in the number of days in a month. Based on my current calculations February will have less revenue than March because of 28 versus 31 days - that shouldn't happen and should be even. I've tried to figure out a solution for this using Days360 function so that each month is treated evenly but I've not managed to figure it out.

    Any thoughts that might work would be appreciated?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. subscription revenue
    By brotherwo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2013, 05:03 PM
  2. Subscription not working?
    By warakawa in forum The Water Cooler
    Replies: 4
    Last Post: 10-23-2010, 03:52 AM
  3. How to set up subscription due notice
    By slindon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2006, 07:51 AM
  4. [SOLVED] Sorting a subscription list
    By Marzban J. Hathiram in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-25-2006, 04:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1