+ Reply to Thread
Results 1 to 5 of 5

Percentage of month passed...

  1. #1
    Registered User
    Join Date
    04-01-2015
    Location
    Delaware
    MS-Off Ver
    2013
    Posts
    4

    Percentage of month passed...

    I have found that I need to keep a daily eye on the amount of data that my family uses on our cell phone plan or else pay the outrageous fees for going over. I'm trying to come up with a spreadsheet that can show how much of the month has passed (as a percentage) and compare that to the amount of data that we have used so far. The thing is, our plan goes from the 29th of one month to the 28th of the next month. I found a formula to calculate the percentage for a standard month (1st-30th or 31st), but can't seem to find a way to modify it for my date range needs.

    So, when I see that we have used 4% of our data and it is the 18th of Feb, I want a quick visual of what percentage of the plan's month (any month) has gone by and see where we stand.

    Thoughts?

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Percentage of month passed...

    Here's an idea.
    Good Luck!!!
    Attached Files Attached Files
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Percentage of month passed...

    Your service provider should be able to give you that, as an option under Settings/Data Usage (at least, verizon has it)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    04-01-2015
    Location
    Delaware
    MS-Off Ver
    2013
    Posts
    4

    Re: Percentage of month passed...

    Exactly what I needed Skywriter. Thanks!

  5. #5
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Percentage of month passed...

    My pleasure.
    Thanks for the feedback and the rep. points.

+ 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. [SOLVED] Count the number of Saturdays that have passed in a month so far
    By Badvgood in forum Excel General
    Replies: 9
    Last Post: 03-16-2014, 04:07 PM
  2. Formula to show how many days have passed since the last day of the month
    By baby_gizmo87 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2014, 09:03 AM
  3. [SOLVED] Forecast calculation - Once month has passed
    By Ktahilramani in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2014, 03:49 AM
  4. Adding up Dates passed in Month
    By kensukebook in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2013, 02:53 AM
  5. Replies: 4
    Last Post: 02-24-2012, 08:12 AM

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