FMHasan
New Member
- Joined
- Nov 2, 2021
- Messages
- 36
- Office Version
- 2016
- Platform
- Windows
New Microsoft Excel Worksheet (2).xlsx | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | K | L | M | N | O | |||
2 | 0-30 | 31-60 | 61-90 | 91-120 | 120-365 | 366- Avobe | ||||||||
3 | Bill No | Bill Date | Aged | Tk | Sum of Tk | Sum of Tk | Sum of Tk | Sum of Tk | Sum of Tk | Sum of Tk | ||||
4 | 100 | 30-06-22 | 90 | 50000 | ||||||||||
5 | 101 | 15-07-22 | 75 | 35000 | ||||||||||
6 | 102 | 30-07-22 | 60 | 56333 | ||||||||||
7 | 103 | 27-06-22 | 93 | 46666 | ||||||||||
8 | 104 | 04-10-22 | -6 | 50004 | ||||||||||
9 | 105 | 05-07-22 | 85 | 50005 | ||||||||||
10 | 106 | 06-06-22 | 114 | 89745 | ||||||||||
11 | 107 | 26-08-22 | 33 | 48000 | ||||||||||
12 | 108 | 08-06-22 | 112 | 69315 | ||||||||||
13 | 109 | 25-05-22 | 126 | 50009 | ||||||||||
14 | 110 | 06-03-22 | 206 | 21365 | ||||||||||
15 | 111 | 31-08-22 | 28 | 25464 | ||||||||||
16 | 112 | 12-09-22 | 16 | 89750 | ||||||||||
17 | 113 | 01-01-21 | 635 | 60000 | ||||||||||
18 | 114 | 01-06-21 | 484 | 56000 | ||||||||||
19 | 115 | 01-10-21 | 362 | 45680 | ||||||||||
Pran |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F4:F19 | F4 | =TODAY()-E4-60 |