srinivasarv
Board Regular
- Joined
- Mar 25, 2008
- Messages
- 62
HI,
Can anyone teach me how to use the function workday
thanks & regards,
srini
Can anyone teach me how to use the function workday
thanks & regards,
srini
Excel Workbook | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Company | Co Name | Inward No | Date | Vendor | Name | BillNo | Bill Dt | Bill amount | Outsanding Days | ||
2 | 3130 | GPEPL | 101633 | 17-Feb-09 | 103316 | TATA TELESERVICES LIMITED | 596467970 | 25.11.2008 | 505.62 | 27 | ||
3 | 3300 | GHWPL | 105196 | 19-Feb-09 | 300751 | FCM TRAVEL SOLUTIONS (I) PVT.L | 9051032716 | 20.01.2009 | 4724 | 25 | ||
4 | 3300 | GHWPL | 105456 | 26-Feb-09 | 300755 | FCM TRAVEL SOLUTIONS (I) PVT.L | 9053004375 | 15.01.2009 | 1620 | 20 | ||
5 | 3300 | GHWPL | 105719 | 2-Mar-09 | 300957 | DG CONSULTANCY SERVICES | CONSUL/FEE | 31.12.2008 | 1250 | 18 | ||
6 | 3300 | GHWPL | 107161 | 9-Mar-09 | 300751 | FCM TRAVEL SOLUTIONS (I) PVT.L | 9051039182 | 10.02.2009 | 7298 | 13 | ||
7 | 3300 | GHWPL | 107164 | 10-Mar-09 | 300751 | FCM TRAVEL SOLUTIONS (I) PVT.L | 9051039170 | 10.02.2009 | 2758 | 12 | ||
8 | 3300 | GHWPL | 107191 | 17-Mar-09 | 101902 | MISCELLANEOUS SUPPLIER(BANK) | CONVEYANCE | 27.01.2009 | 1360 | 7 | ||
9 | 3230 | GUEPL | 106814 | 18-Mar-09 | 304847 | HOTEL ANNAMALAI | 9111 | 26.01.2009 | 2610 | 6 | ||
10 | 3230 | GUEPL | 106815 | 23-Mar-09 | 302855 | PERFORM SOLUTIONS | 22 | 27.01.2009 | 20225 | 3 | ||
Sheet1 |
Excel Workbook | ||
---|---|---|
Sheet |
Excel Workbook
A B C D E F G H I J 1 Company Co Name Inward No Date Vendor Name BillNo Bill Dt Bill amount Outsanding Days 2 3130 GPEPL 101633 17-Feb-09 103316 TATA TELESERVICES LIMITED 596467970 25.11.2008 505.62 27 3 3300 GHWPL 105196 19-Feb-09 300751 FCM TRAVEL SOLUTIONS (I) PVT.L 9051032716 20.01.2009 4724 25 4 3300 GHWPL 105456 26-Feb-09 300755 FCM TRAVEL SOLUTIONS (I) PVT.L 9053004375 15.01.2009 1620 20 5 3300 GHWPL 105719 2-Mar-09 300957 DG CONSULTANCY SERVICES CONSUL/FEE 31.12.2008 1250 18 6 3300 GHWPL 107161 9-Mar-09 300751 FCM TRAVEL SOLUTIONS (I) PVT.L 9051039182 10.02.2009 7298 13 7 3300 GHWPL 107164 10-Mar-09 300751 FCM TRAVEL SOLUTIONS (I) PVT.L 9051039170 10.02.2009 2758 12 8 3300 GHWPL 107191 17-Mar-09 101902 MISCELLANEOUS SUPPLIER(BANK) CONVEYANCE 27.01.2009 1360 7 9 3230 GUEPL 106814 18-Mar-09 304847 HOTEL ANNAMALAI 9111 26.01.2009 2610 6 10 3230 GUEPL 106815 23-Mar-09 302855 PERFORM SOLUTIONS 22 27.01.2009 20225 3 Sheet1</TD></TR></TABLE></TD></TR></TABLE>#VALUE!