Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
HI, we have the following data where we count the delay but don't want to count the Sunday
Delay will be count if column g will be bigger then column D
and also in Column G5, its blank but date is over so want to count delay in this cell also
Date | Order | P Name | TG | Qty | Recd. Date | Recd. Qty | Delay | ||
27/4/2010 | Given | TEST 1 | 4/29/2010 | 500 | 4/27/2010 | 500 | |||
9/5/2010 | Given | TEST 2 | 5/16/2010 | 200 | 5/20/2010 | 150 | |||
9/5/2010 | Given | TEST 3 | 5/16/2010 | 150 | 5/17/2010 | 150 | |||
10/5/2010 | Given | TEST 4 | 5/17/2010 | 600 | Not recd. till now and date is over | ||||
10/5/2010 | Given | TEST 5 | 5/17/2010 | 254 | 5/16/2010 | 254 | |||
12/5/2010 | Given | TEST 6 | 5/19/2010 | 654 | 5/18/2010 | 654 | |||
12/5/2010 | Given | TEST 7 | 5/19/2010 | 951 | 6/10/2010 | 950 | |||
12/5/2010 | Given | TEST 8 | 5/19/2010 | 757 | 6/15/2010 | 757 | |||
Delay will be count if column g will be bigger then column D
and also in Column G5, its blank but date is over so want to count delay in this cell also