I am calculating weekly revenue where lets say for November'22 the last week is starting from Monday 28-Nov and the month ends on Wednesday 30th Nov. So I need to consider only 3 days for that week instead of 5 till Friday 2nd Dec. Now these leftover days of the week should get added in the next week. next week which is starting from 5th Of Dec till Sun 11th Dec should consider the additional 2 days.
Can anyone help me?
Screenshot 2022-09-14 133750.png
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You probably somehow calculate end of week which is used in "net work days" row. Instead of using this date, use such formula
Formula:
Please Login or Register to view this content.
This deald with "5 instead of 3" problem
also you can calculate a difference of "old approach count" - "new approach count" for previous week and if its >0 (you can use function MAX(0,calculated difference) add it to current week count.
Anyway - with the attachment the help would be with "excact formulas", but may be you will be able to create them yourself with the above propositions.
Last edited by Kaper; 10-01-2022 at 05:30 AM.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks