MohitMathur
New Member
- Joined
- May 26, 2014
- Messages
- 12
Hi All,
Please find the attached file, where I am finding date in column 'C' and here condition, if sat and sun comes so ignore the date and jump on Next working day but for Monday it will jump on wed because 09Jul and 10 Jul task already been assigned.
Regards
Mohit
[TABLE="width: 216"]
<tbody>[TR]
[TD="class: xl66, width: 72"]Day[/TD]
[TD="class: xl67, width: 72"]Date1[/TD]
[TD="class: xl68, width: 72"]Output[/TD]
[/TR]
[TR]
[TD="class: xl69"]Thu[/TD]
[TD="class: xl65, align: right"]5-Jul-18[/TD]
[TD="class: xl70, align: right"]5-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Thu[/TD]
[TD="class: xl65, align: right"]5-Jul-18[/TD]
[TD="class: xl70, align: right"]5-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Thu[/TD]
[TD="class: xl65, align: right"]5-Jul-18[/TD]
[TD="class: xl70, align: right"]5-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Fri[/TD]
[TD="class: xl65, align: right"]6-Jul-18[/TD]
[TD="class: xl70, align: right"]6-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Fri[/TD]
[TD="class: xl65, align: right"]6-Jul-18[/TD]
[TD="class: xl70, align: right"]6-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Fri[/TD]
[TD="class: xl65, align: right"]6-Jul-18[/TD]
[TD="class: xl70, align: right"]6-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sat[/TD]
[TD="class: xl65, align: right"]7-Jul-18[/TD]
[TD="class: xl70, align: right"]9-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sat[/TD]
[TD="class: xl65, align: right"]7-Jul-18[/TD]
[TD="class: xl70, align: right"]9-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sat[/TD]
[TD="class: xl65, align: right"]7-Jul-18[/TD]
[TD="class: xl70, align: right"]9-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sun[/TD]
[TD="class: xl65, align: right"]8-Jul-18[/TD]
[TD="class: xl70, align: right"]10-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sun[/TD]
[TD="class: xl65, align: right"]8-Jul-18[/TD]
[TD="class: xl70, align: right"]10-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sun[/TD]
[TD="class: xl65, align: right"]8-Jul-18[/TD]
[TD="class: xl70, align: right"]10-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Mon[/TD]
[TD="class: xl65, align: right"]9-Jul-18[/TD]
[TD="class: xl71, align: right"]11-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Mon[/TD]
[TD="class: xl65, align: right"]9-Jul-18[/TD]
[TD="class: xl71, align: right"]11-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl72"]Mon[/TD]
[TD="class: xl73, align: right"]9-Jul-18[/TD]
[TD="class: xl74, align: right"]11-Jul-18[/TD]
[/TR]
</tbody>[/TABLE]
Please find the attached file, where I am finding date in column 'C' and here condition, if sat and sun comes so ignore the date and jump on Next working day but for Monday it will jump on wed because 09Jul and 10 Jul task already been assigned.
Regards
Mohit
[TABLE="width: 216"]
<tbody>[TR]
[TD="class: xl66, width: 72"]Day[/TD]
[TD="class: xl67, width: 72"]Date1[/TD]
[TD="class: xl68, width: 72"]Output[/TD]
[/TR]
[TR]
[TD="class: xl69"]Thu[/TD]
[TD="class: xl65, align: right"]5-Jul-18[/TD]
[TD="class: xl70, align: right"]5-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Thu[/TD]
[TD="class: xl65, align: right"]5-Jul-18[/TD]
[TD="class: xl70, align: right"]5-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Thu[/TD]
[TD="class: xl65, align: right"]5-Jul-18[/TD]
[TD="class: xl70, align: right"]5-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Fri[/TD]
[TD="class: xl65, align: right"]6-Jul-18[/TD]
[TD="class: xl70, align: right"]6-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Fri[/TD]
[TD="class: xl65, align: right"]6-Jul-18[/TD]
[TD="class: xl70, align: right"]6-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Fri[/TD]
[TD="class: xl65, align: right"]6-Jul-18[/TD]
[TD="class: xl70, align: right"]6-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sat[/TD]
[TD="class: xl65, align: right"]7-Jul-18[/TD]
[TD="class: xl70, align: right"]9-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sat[/TD]
[TD="class: xl65, align: right"]7-Jul-18[/TD]
[TD="class: xl70, align: right"]9-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sat[/TD]
[TD="class: xl65, align: right"]7-Jul-18[/TD]
[TD="class: xl70, align: right"]9-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sun[/TD]
[TD="class: xl65, align: right"]8-Jul-18[/TD]
[TD="class: xl70, align: right"]10-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sun[/TD]
[TD="class: xl65, align: right"]8-Jul-18[/TD]
[TD="class: xl70, align: right"]10-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Sun[/TD]
[TD="class: xl65, align: right"]8-Jul-18[/TD]
[TD="class: xl70, align: right"]10-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Mon[/TD]
[TD="class: xl65, align: right"]9-Jul-18[/TD]
[TD="class: xl71, align: right"]11-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl69"]Mon[/TD]
[TD="class: xl65, align: right"]9-Jul-18[/TD]
[TD="class: xl71, align: right"]11-Jul-18[/TD]
[/TR]
[TR]
[TD="class: xl72"]Mon[/TD]
[TD="class: xl73, align: right"]9-Jul-18[/TD]
[TD="class: xl74, align: right"]11-Jul-18[/TD]
[/TR]
</tbody>[/TABLE]