Delay in days from collection and till depositing

[joemon]

Using 5 details, Store code, Date of Sales, Sales amount, Date of deposit and Deposit amount, Check if there is a Sales on a particular date and check any deposit is made against that collection is deposited in next day, unless it’s a Sunday. If not find how many days it took deposit from the date of collection till next date of deposit and put it in range of Delay of 1 day, Delay of 2-3 days, Delay of 4-5 days, Delay of 5-10 days, Delay more than 10 Days.(Note Deposit is even happening 2 or 3 days after)

 

[pecoflyer]

Cross post https://www.mrexcel.com/board/threads/delay-in-depositing-collection.1240169/

 

[vletm]

joemon​

Please reread Forum Rules - those are for You too:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

 

[joemon]

Sorry guys, yes I have posted this query in Mr. Excel, since i was not able to attach the entire query working file up there.
Noted and thanks.

 

[anishms]

Using 5 details, Store code, Date of Sales, Sales amount, Date of deposit and Deposit amount, Check if there is a Sales on a particular date and check any deposit is made against that collection is deposited in next day, unless it’s a Sunday. If not find how many days it took deposit from the date of collection till next date of deposit and put it in range of Delay of 1 day, Delay of 2-3 days, Delay of 4-5 days, Delay of 5-10 days, Delay more than 10 Days.(Note Deposit is even happening 2 or 3 days after)

	Store code	1	2	3
NA	NA	1	0	8
1	No delay	10	18	2
2​	Delay of 1 day	9	8	3
4​	Delay of 2-3 day	9	4	5
6​	Delay of 4-5 days	2	0	4
11​	Delay of 6-10 days	0	1	8
	Delay of more than 10 days	0	0	0