Results 1 to 6 of 6

Calculate days in month after a given date

Threaded View

  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    380

    Calculate days in month after a given date

    Hi all

    On the attached example i am trying to determine a few things:
    Column C has a launch date of an initiative, and column D shows how many calls per month this initiative is expected to generate.
    What I want to achieve when a launch date is entered is as follows:
    - produce 0 for any months prior to launch date.
    - calculate the number of days left in the month that the launch date is in including actual launch date as day 1 (workdays or weekends does not matter), and calculate the number of calls relative to this (eg if there are 15 days left out of a 28 day month, then 15/28*call volume would be the figure displayed).
    - all months following the launch date will have the full amount of calls displayed, regardless of how many days are in the month (ie February shows the same number as March even though they have 28 and 31 days respectively)

    I have been able to identify days in the month, as well as taking a date and subtracting the launch date, but cant work out how to limit it to that particular month (eg row 5 takes the first of the month and subtracts the launch date to give a total # of days.

    Thanks
    Darren.
    Attached Files Attached Files
    Last edited by Grimace; 12-20-2010 at 12:42 AM.

Thread Information

Users Browsing this Thread

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

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