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.
Bookmarks