My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

EOMONTH query for distributing a project volume over a period of time, with the breakdown in weeks (date as end of each week)|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / EOMONTH query for distributing a project volume over a period of time, with the breakdown in weeks (date as end of each week)|General Excel Questions & Answers|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
EOMONTH query for distributing a project volume over a period of time, with the breakdown in weeks (date as end of each week)
Avatar
Madi J

New Member
Members
Level 0
Forum Posts: 1
Member Since:
June 5, 2019
sp_UserOfflineSmall Offline
1
June 12, 2019 - 11:22 am
sp_Permalink sp_Print

Hi,

 

I have a query regarding breaking down a project volume over weeks, with the date as end of each week. 

 

Please find attached my current file. 

My current formula shows the first week that the volume hits as the total volume, and then depreciates it each week forward. 

sp_AnswersTopicSeeAnswer See Answer
Avatar
Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands

VIP
Members
Level 2
Forum Posts: 346
Member Since:
April 21, 2015
sp_UserOfflineSmall Offline
2
June 12, 2019 - 6:16 pm
sp_Permalink sp_Print

Try attaching the file again Madi J, can´t find it now!

Frans

sp_AnswersTopicAnswer
Answers Post
sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Vishal Nevase, John Kobiela, Sue Hammond, Lia Ro, Malcolm Sawyer
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6355
Posts: 27792

 

Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen