Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,614
- Office Version
- 365
- 2013
- Platform
- Windows
I have below data now I want to distribute amount in column F based on start and end date to particular month based on their days
So for example
in first two dates 27 days of July, 31 days of August and 16 days of September and allocate amount based on number of days of a particular month
So for example
in first two dates 27 days of July, 31 days of August and 16 days of September and allocate amount based on number of days of a particular month
Links Tuition 22-23.xlsx | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | |||
1 | 2022 | 2023 | |||||||||||||||||||||||||
2 | District/Parent | Student | Duration | Amount | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | |||||
3 | Expected | 932.43 | 1070.57 | 552.55 | |||||||||||||||||||||||
4 | |||||||||||||||||||||||||||
5 | Murray, Lisa | Murray, Jake | Start | End | 187.50 | ||||||||||||||||||||||
6 | Stamford | Charly, Peter | 7/5/2022 | 9/17/2022 | 74 | 2555.55 | |||||||||||||||||||||
7 | Darien P.S. | Johns, Judah | 6/29/2022 | 9/23/2022 | 86 | 10591.27 | |||||||||||||||||||||
8 | Norwalk P.S. | Botens Daniel | 12/1/2022 | 3/10/2023 | 99 | 22700.00 | |||||||||||||||||||||
9 | Leonard Santorelli | Bates, Sienna | 11/21/2022 | 1/13/2023 | 53 | 14750.00 | |||||||||||||||||||||
10 | Darien P.S. | Herne, Anabel "Tobi" | 12/5/2022 | 1/20/2023 | 46 | 15250.00 | |||||||||||||||||||||
11 | Merrill, John | Merrill, Poppy | 12/5/2022 | 1/6/2023 | 32 | 8000.00 | |||||||||||||||||||||
12 | Stamford P.S. | Academic Support for ESS/BGC | 12/5/2022 | 1/20/2023 | 46 | 26735.00 | |||||||||||||||||||||
13 | Norwalk P.S. | Sullivan Jennifer | 12/5/2022 | 1/20/2023 | 46 | 5900.00 | |||||||||||||||||||||
14 | Darien P.S. | Steinkraus Griffin | 1/3/2023 | 4/7/2023 | 94 | 28375.00 | |||||||||||||||||||||
15 | Stamford P.S. | Reicin, Tina | 12/16/2022 | 12/22/2023 | 371 | 1260.00 | |||||||||||||||||||||
16 | Greenwich P.S. | Ginste, Elsa | 1/3/2023 | 3/31/2023 | 87 | 22700.00 | |||||||||||||||||||||
17 | VanWyk, Mark | VanWyk, Beckett | 1/3/2023 | 4/7/2023 | 94 | 28375.00 | |||||||||||||||||||||
18 | Lamendola, Kristin | Fallon, Kyle | 12/27/2022 | 12/30/2022 | 3 | 910.00 | |||||||||||||||||||||
19 | Kornstein, Andrew | Kornstein, Lleyton | 1/1/2023 | 3/4/2023 | 62 | 14750.00 | |||||||||||||||||||||
20 | Blanchard, Robert | Blanchard, Henry | 1/9/2023 | 1/24/2023 | 15 | 2800.00 | |||||||||||||||||||||
21 | Greenwich P.S. | Casey, Thalia | 1/9/2023 | 2/24/2023 | 46 | 11800.00 | |||||||||||||||||||||
22 | Edwards, John | Edwards, Hayley | 1/6/2023 | 2/24/2023 | 49 | 11800.00 | |||||||||||||||||||||
23 | Yahong, Chen | Li, Leon | 2/1/2023 | 4/21/2023 | 79 | 23050.00 | |||||||||||||||||||||
24 | Prescott, Finnian | Prescott, Claire | 1/23/2023 | 4/21/2023 | 88 | 5675.00 | |||||||||||||||||||||
25 | Sherman, Scott | Sherman, Matt | 1/23/2023 | 4/28/2023 | 95 | 28875.00 | |||||||||||||||||||||
26 | Brockman, Rhonda | Brockman, Jack | 1/23/2023 | 5/5/2023 | 102 | 23200.00 | |||||||||||||||||||||
27 | Darien P.S. | Herne, Anabel "Tobi" | 1/23/2023 | 3/10/2023 | 46 | 5900.00 | |||||||||||||||||||||
28 | Mottola, Thomas | Mottola, Sakae | 1/26/2023 | 3/24/2023 | 57 | 15250.00 | |||||||||||||||||||||
29 | Proctor, Diane | Proctor, Kelly | 1/31/2023 | 6/9/2023 | 129 | 37300.00 | |||||||||||||||||||||
30 | Darien P.S. | Hagander, Ashley | 1/20/2023 | 5/12/2023 | 112 | 11350.00 | |||||||||||||||||||||
31 | Stamford P.S. | Academic Support for ESS/BGC | 1/23/2023 | 3/17/2023 | 53 | 26735.00 | |||||||||||||||||||||
32 | Lamendola, Kristin | Fallon, Kyle | 1/30/2023 | 4/28/2023 | 88 | 17525.00 | |||||||||||||||||||||
33 | Norwalk P.S. | Sullivan, Jennifer | 1/23/2023 | 3/17/2023 | 53 | 5900.00 | |||||||||||||||||||||
34 | Merrill, John | Merrill, Poppy | 1/23/2023 | 5/12/2023 | 109 | 14980.00 | |||||||||||||||||||||
35 | Stamford P.S. | Vita, Sophia | 2/3/2023 | 4/14/2023 | 70 | 2025.00 | |||||||||||||||||||||
36 | Kliatchko, Vladimir | Kilatchko, Robin | 1/27/2023 | 6/9/2023 | 133 | 11525.00 | |||||||||||||||||||||
37 | Private | Lovett, Chloe | 2/6/2023 | 5/5/2023 | 88 | 28375.00 | |||||||||||||||||||||
38 | Bradley, Ashley | Bradley, Oliver | 2/13/2023 | 3/31/2023 | 46 | 12300.00 | |||||||||||||||||||||
39 | Blanchard, Robert | Blanchard, Henry | 1/30/2023 | 3/4/2023 | 33 | 6720.00 | |||||||||||||||||||||
40 | Nemec, Suzanne | Nemec Phillip | 2/22/2023 | 3/15/2023 | 21 | 2450.00 | |||||||||||||||||||||
41 | Kornstein, Andrew | Kornstein, Lleyton | 3/6/2023 | 5/12/2023 | 67 | 19200.00 | |||||||||||||||||||||
42 | Greenwich P.S. | Casey, Thalia | 2/27/2023 | 6/16/2023 | 109 | 29500.00 | |||||||||||||||||||||
43 | Town of Darien | Vasquez, Enrique | 3/2/2023 | 5/15/2023 | 74 | 36775.00 | |||||||||||||||||||||
44 | Nudelman, Nikki | Nudelman, Sammy | 3/2/2023 | 5/12/2023 | 71 | 15860.00 | |||||||||||||||||||||
45 | Norwalk P.S. | Botens Daniel | 3/13/2023 | 6/16/2023 | 95 | 11350.00 | |||||||||||||||||||||
46 | Norwalk P.S. | Sullivan, Jenniver | 3/20/2023 | 5/3/2023 | 44 | 5900.00 | |||||||||||||||||||||
47 | Private | Sciglimpaglia, Eden | 3/13/2023 | 6/16/2023 | 95 | 15000.00 | |||||||||||||||||||||
48 | Sherman, Scott | Sherman, Matt | 3/6/2023 | 7/14/2023 | 130 | 11525.00 | |||||||||||||||||||||
49 | Town of Darien | Tucker, Thier | 3/20/2023 | 6/9/2023 | 81 | 11850.00 | |||||||||||||||||||||
50 | Stamford P.S. | Academic Support for ESS/BGC | 3/20/2023 | 5/5/2023 | 46 | 26735.00 | |||||||||||||||||||||
51 | Private | Nusseibeh, Anisa | 3/27/2023 | 5/19/2023 | 53 | 15360.00 | |||||||||||||||||||||
52 | Lamendola, Kristin | Fallon, Kyle | 3/27/2023 | 6/9/2023 | 74 | 5675.00 | |||||||||||||||||||||
53 | Stamford P.S. | Condlin, Emma | 3/29/2023 | 6/16/2023 | 79 | 11850.00 | |||||||||||||||||||||
54 | Mottola, Thomas | Mottola, Sakae | 3/27/2023 | 5/12/2023 | 46 | 14750.00 | |||||||||||||||||||||
55 | Greenwich P.S. | Ginste, Elsa | 4/3/2023 | 6/16/2023 | 74 | 14300.00 | |||||||||||||||||||||
56 | Stamford P.S. | Sikiotis, Tristen | 4/11/2023 | 6/23/2023 | 73 | 23200.00 | |||||||||||||||||||||
57 | Private | Howe, Alexandar | 4/5/2023 | 5/12/2023 | 37 | 15250.00 | |||||||||||||||||||||
58 | Private | Nusseibeh, Sarimir | 3/30/2023 | 5/19/2023 | 50 | 15360.00 | |||||||||||||||||||||
59 | Darien P.S. | Gracia, Jeraldine | 4/17/2023 | 6/30/2023 | 74 | 29100.00 | |||||||||||||||||||||
60 | Goodwin, Seth | Goodwin, Sage | 4/19/2023 | 6/9/2023 | 51 | 3840.00 | |||||||||||||||||||||
61 | Stamford P.S. | Talbot, Jason | 5/15/2023 | 6/30/2023 | 46 | 9350.00 | |||||||||||||||||||||
62 | Josh, Gershon | Gershon, Josh | 4/27/2023 | 6/9/2023 | 43 | 2950.00 | |||||||||||||||||||||
63 | Darien P.S. | Piersol, Gavin | 5/4/2023 | 6/30/2023 | 57 | 20870.00 | |||||||||||||||||||||
64 | Darien P.S. | Hagen, Duke | 4/26/2023 | 6/30/2023 | 65 | 23425.00 | |||||||||||||||||||||
65 | Stamford P.S. | Academic Support for ESS/BGC | 5/8/2023 | 6/15/2023 | 38 | 26735.00 | |||||||||||||||||||||
66 | Greenwich P.S. | Blackwell, Ru | 5/9/2023 | 6/16/2023 | 38 | 15250.00 | |||||||||||||||||||||
67 | Stamford P.S. | Franco, Zaire | 5/15/2023 | 6/23/2023 | 39 | 15750.00 | |||||||||||||||||||||
68 | Darien P.S. | Johnson, William | 4/27/2023 | 5/10/2023 | 13 | 2460.00 | |||||||||||||||||||||
69 | Northfield Mount Herman | Thomas, Gabby | 5/9/2023 | 6/23/2023 | 45 | 5900.00 | |||||||||||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E6:E69 | E6 | =DAYS(D6,C6) |