Spreadsheet: 393971d1431193432-formula-to-find-next-business-day-nextbusinessday
Sheet: Sheet1

 |  |  |  | Eg:- 6/5/2015 7:33 AM -> desired result should be 7/5/2015 7:33 AM (Time remains same since it falls between 7AM-4PM bracket)
2015-05-01 00:00:00
2015-05-01 01:00:00 |  |  |  | 2nd example, 6/5/2015 6:00PM -> desired result should be 7/5/2015 4:00 PM (To ensure time is at End of business)
2015-05-01 01:59:59.990000
2015-05-01 02:59:59.985000
2015-05-01 03:59:59.980000 |  |  |  | WORKDAY.INTL($F4,1,7)+TIME(HOUR("07:00"),0,0)
2015-05-01 04:59:59.975000
2015-05-01 05:59:59.970000
2015-05-01 06:59:59.965000
2015-05-01 07:59:59.960000
2015-05-01 08:59:59.955000
2015-05-01 09:59:59.950000
2015-05-01 10:59:59.945000
2015-05-01 11:59:59.940000
2015-05-01 12:59:59.935000
2015-05-01 13:59:59.930000
2015-05-01 14:59:59.925000
2015-05-01 15:59:59.920000
2015-05-01 16:59:59.915000
2015-05-01 17:59:59.910000
2015-05-01 18:59:59.905000
2015-05-01 19:59:59.900000
2015-05-01 20:59:59.895000
2015-05-01 21:59:59.890000
2015-05-01 22:59:59.885000
2015-05-01 23:59:59.880000
2015-05-02 00:59:59.875000
2015-05-02 01:59:59.870000
2015-05-02 02:59:59.865000
2015-05-02 03:59:59.860000
2015-05-02 04:59:59.855000
2015-05-02 05:59:59.850000
2015-05-02 06:59:59.845000
2015-05-02 07:59:59.840000
2015-05-02 08:59:59.835000
2015-05-02 09:59:59.830000
2015-05-02 10:59:59.825000
2015-05-02 11:59:59.820000
2015-05-02 12:59:59.815000
2015-05-02 13:59:59.810000
2015-05-02 14:59:59.805000
2015-05-02 15:59:59.800000
2015-05-02 16:59:59.795000
2015-05-02 17:59:59.790000
2015-05-02 18:59:59.785000
2015-05-02 19:59:59.780000
2015-05-02 20:59:59.775000
2015-05-02 21:59:59.770000
2015-05-02 22:59:59.765000
2015-05-02 23:59:59.760000
2015-05-03 00:59:59.755000
2015-05-03 01:59:59.750000
2015-05-03 02:59:59.745000
2015-05-03 03:59:59.740000
2015-05-03 04:59:59.735000
2015-05-03 05:59:59.730000
2015-05-03 06:59:59.725000
2015-05-03 07:59:59.720000
2015-05-03 08:59:59.715000
2015-05-03 09:59:59.710000
2015-05-03 10:59:59.705000
2015-05-03 11:59:59.700000
2015-05-03 12:59:59.695000
2015-05-03 13:59:59.690000
2015-05-03 14:59:59.685000
2015-05-03 15:59:59.680000
2015-05-03 16:59:59.675000
2015-05-03 17:59:59.670000
2015-05-03 18:59:59.665000
2015-05-03 19:59:59.660000
2015-05-03 20:59:59.655000
2015-05-03 21:59:59.650000
2015-05-03 22:59:59.645000
2015-05-03 23:59:59.610000
2015-05-04 00:59:59.600000
2015-05-04 01:59:59.590000
2015-05-04 02:59:59.580000
2015-05-04 03:59:59.570000
2015-05-04 04:59:59.560000
2015-05-04 05:59:59.550000
2015-05-04 06:59:59.540000
2015-05-04 07:59:59.530000
2015-05-04 08:59:59.520000
2015-05-04 09:59:59.510000
2015-05-04 10:59:59.500000
2015-05-04 11:59:59.490000
2015-05-04 12:59:59.480000
2015-05-04 13:59:59.470000
2015-05-04 14:59:59.460000
2015-05-04 15:59:59.450000
2015-05-04 16:59:59.440000
2015-05-04 17:59:59.430000
2015-05-04 18:59:59.420000
2015-05-04 19:59:59.410000
2015-05-04 20:59:59.400000
2015-05-04 21:59:59.390000
2015-05-04 22:59:59.380000
2015-05-04 23:59:59.370000
2015-05-05 00:59:59.360000
2015-05-05 01:59:59.350000
2015-05-05 02:59:59.340000
2015-05-05 03:59:59.330000
2015-05-05 04:59:59.320000
2015-05-05 05:59:59.310000
2015-05-05 06:59:59.300000
2015-05-05 07:59:59.290000
2015-05-05 08:59:59.280000
2015-05-05 09:59:59.270000
2015-05-05 10:59:59.260000
2015-05-05 11:59:59.250000
2015-05-05 12:59:59.240000
2015-05-05 13:59:59.230000
2015-05-05 14:59:59.220000
2015-05-05 15:59:59.210000
2015-05-05 16:59:59.200000
2015-05-05 17:59:59.190000
2015-05-05 18:59:59.180000
2015-05-05 19:59:59.170000
2015-05-05 20:59:59.160000
2015-05-05 21:59:59.150000
2015-05-05 22:59:59.140000
2015-05-05 23:59:59.130000
2015-05-06 00:59:59.120000
2015-05-06 01:59:59.110000
2015-05-06 02:59:59.100000
2015-05-06 03:59:59.090000
2015-05-06 04:59:59.080000
2015-05-06 05:59:59.070000
2015-05-06 06:59:59.060000
2015-05-06 07:59:59.050000
2015-05-06 08:59:59.040000
2015-05-06 09:59:59.030000
2015-05-06 10:59:59.020000
2015-05-06 11:59:59.010000
2015-05-06 12:59:59
2015-05-06 13:59:58.990000
2015-05-06 14:59:58.980000
2015-05-06 15:59:58.970000
2015-05-06 16:59:58.960000
2015-05-06 17:59:58.950000
2015-05-06 18:59:58.940000
2015-05-06 19:59:58.930000
2015-05-06 20:59:58.920000
2015-05-06 21:59:58.910000
2015-05-06 22:59:58.900000
2015-05-06 23:59:58.890000
2015-05-07 00:59:58.880000
2015-05-07 01:59:58.870000
2015-05-07 02:59:58.860000
2015-05-07 03:59:58.850000
2015-05-07 04:59:58.840000
2015-05-07 05:59:58.830000
2015-05-07 06:59:58.820000
2015-05-07 07:59:58.810000
2015-05-07 08:59:58.800000
2015-05-07 09:59:58.790000
2015-05-07 10:59:58.780000
2015-05-07 11:59:58.770000
2015-05-07 12:59:58.760000
2015-05-07 13:59:58.750000
2015-05-07 14:59:58.740000
2015-05-07 15:59:58.730000
2015-05-07 16:59:58.720000
2015-05-07 17:59:58.710000
2015-05-07 18:59:58.700000
2015-05-07 19:59:58.690000
2015-05-07 20:59:58.680000
2015-05-07 21:59:58.670000
2015-05-07 22:59:58.660000
2015-05-07 23:59:58.650000
2015-05-08 00:59:58.640000
2015-05-08 01:59:58.630000
2015-05-08 02:59:58.620000
2015-05-08 03:59:58.610000
2015-05-08 04:59:58.600000
2015-05-08 05:59:58.590000
2015-05-08 06:59:58.580000
2015-05-08 07:59:58.570000
2015-05-08 08:59:58.560000
2015-05-08 09:59:58.550000
2015-05-08 10:59:58.540000
2015-05-08 11:59:58.530000
2015-05-08 12:59:58.520000
2015-05-08 13:59:58.510000
2015-05-08 14:59:58.500000
2015-05-08 15:59:58.490000
2015-05-08 16:59:58.480000
2015-05-08 17:59:58.470000
2015-05-08 18:59:58.460000
2015-05-08 19:59:58.450000
2015-05-08 20:59:58.440000
2015-05-08 21:59:58.430000
2015-05-08 22:59:58.420000
2015-05-08 23:59:58.410000
2015-05-09 00:59:58.400000
2015-05-09 01:59:58.390000
2015-05-09 02:59:58.380000
2015-05-09 03:59:58.370000
2015-05-09 04:59:58.360000
2015-05-09 05:59:58.350000
2015-05-09 06:59:58.340000
2015-05-09 07:59:58.330000
2015-05-09 08:59:58.320000
2015-05-09 09:59:58.310000
2015-05-09 10:59:58.300000
2015-05-09 11:59:58.290000
2015-05-09 12:59:58.280000
2015-05-09 13:59:58.270000
2015-05-09 14:59:58.260000
2015-05-09 15:59:58.250000
2015-05-09 16:59:58.240000
2015-05-09 17:59:58.230000
2015-05-09 18:59:58.220000
2015-05-09 19:59:58.210000
2015-05-09 20:59:58.200000
2015-05-09 21:59:58.190000
2015-05-09 22:59:58.180000
2015-05-09 23:59:58.170000
2015-05-10 00:59:58.160000
2015-05-10 01:59:58.150000
2015-05-10 02:59:58.140000
2015-05-10 03:59:58.130000
2015-05-10 04:59:58.120000
2015-05-10 05:59:58.110000
2015-05-10 06:59:58.100000
2015-05-10 07:59:58.090000
2015-05-10 08:59:58.080000
2015-05-10 09:59:58.070000
2015-05-10 10:59:58.060000
2015-05-10 11:59:58.050000
2015-05-10 12:59:58.040000
2015-05-10 13:59:58.030000
2015-05-10 14:59:58.020000
2015-05-10 15:59:58.010000
2015-05-10 16:59:58
2015-05-10 17:59:57.990000
2015-05-10 18:59:57.980000
2015-05-10 19:59:57.970000
2015-05-10 20:59:57.960000
2015-05-10 21:59:57.950000
2015-05-10 22:59:57.940000
2015-05-10 23:59:57.930000
2015-05-11 00:59:57.920000
2015-05-11 01:59:57.910000
2015-05-11 02:59:57.900000
2015-05-11 03:59:57.890000
2015-05-11 04:59:57.880000
2015-05-11 05:59:57.870000
2015-05-11 06:59:57.860000
2015-05-11 07:59:57.850000
2015-05-11 08:59:57.840000
2015-05-11 09:59:57.830000
2015-05-11 10:59:57.820000
2015-05-11 11:59:57.810000
2015-05-11 12:59:57.800000
2015-05-11 13:59:57.790000
2015-05-11 14:59:57.780000
2015-05-11 15:59:57.770000
2015-05-11 16:59:57.760000
2015-05-11 17:59:57.750000
2015-05-11 18:59:57.740000
2015-05-11 19:59:57.730000
2015-05-11 20:59:57.720000
2015-05-11 21:59:57.710000
2015-05-11 22:59:57.700000
2015-05-11 23:59:57.690000
2015-05-12 00:59:57.680000
2015-05-12 01:59:57.670000
2015-05-12 02:59:57.660000
2015-05-12 03:59:57.650000
2015-05-12 04:59:57.640000
2015-05-12 05:59:57.630000
2015-05-12 06:59:57.620000
2015-05-12 07:59:57.610000
2015-05-12 08:59:57.600000
2015-05-12 09:59:57.590000
2015-05-12 10:59:57.580000
2015-05-12 11:59:57.570000
2015-05-12 12:59:57.560000
2015-05-12 13:59:57.550000
2015-05-12 14:59:57.540000
2015-05-12 15:59:57.530000
2015-05-12 16:59:57.520000
2015-05-12 17:59:57.510000
2015-05-12 18:59:57.500000
2015-05-12 19:59:57.490000
2015-05-12 20:59:57.480000
2015-05-12 21:59:57.470000
2015-05-12 22:59:57.460000
2015-05-12 23:59:57.450000
2015-05-13 00:59:57.440000
2015-05-13 01:59:57.430000
2015-05-13 02:59:57.420000
2015-05-13 03:59:57.410000
2015-05-13 04:59:57.400000
2015-05-13 05:59:57.390000
2015-05-13 06:59:57.380000
2015-05-13 07:59:57.370000
2015-05-13 08:59:57.360000
2015-05-13 09:59:57.350000
2015-05-13 10:59:57.340000
2015-05-13 11:59:57.330000
2015-05-13 12:59:57.320000
2015-05-13 13:59:57.310000
2015-05-13 14:59:57.300000
2015-05-13 15:59:57.290000
2015-05-13 16:59:57.280000
2015-05-13 17:59:57.270000
2015-05-13 18:59:57.260000
2015-05-13 19:59:57.250000
2015-05-13 20:59:57.240000
2015-05-13 21:59:57.230000
2015-05-13 22:59:57.220000
2015-05-13 23:59:57.210000
2015-05-14 00:59:57.200000
2015-05-14 01:59:57.190000
2015-05-14 02:59:57.180000
2015-05-14 03:59:57.170000
2015-05-14 04:59:57.160000
2015-05-14 05:59:57.150000
2015-05-14 06:59:57.140000
2015-05-14 07:59:57.130000
2015-05-14 08:59:57.120000
2015-05-14 09:59:57.110000
2015-05-14 10:59:57.100000
2015-05-14 11:59:57.090000
2015-05-14 12:59:57.080000
2015-05-14 13:59:57.070000
2015-05-14 14:59:57.060000
2015-05-14 15:59:57.050000
2015-05-14 16:59:57.040000
2015-05-14 17:59:57.030000
2015-05-14 18:59:57.020000
2015-05-14 19:59:57.010000
2015-05-14 20:59:57
2015-05-14 21:59:56.990000
2015-05-14 22:59:56.980000
2015-05-14 23:59:56.970000
2015-05-15 00:59:56.960000
2015-05-15 01:59:56.950000
2015-05-15 02:59:56.940000
2015-05-15 03:59:56.930000
2015-05-15 04:59:56.920000
2015-05-15 05:59:56.910000
2015-05-15 06:59:56.900000
2015-05-15 07:59:56.890000
2015-05-15 08:59:56.880000
2015-05-15 09:59:56.870000
2015-05-15 10:59:56.860000
2015-05-15 11:59:56.850000
2015-05-15 12:59:56.840000
2015-05-15 13:59:56.830000
2015-05-15 14:59:56.820000
2015-05-15 15:59:56.810000
2015-05-15 16:59:56.800000
2015-05-15 17:59:56.790000
2015-05-15 18:59:56.780000
2015-05-15 19:59:56.770000
2015-05-15 20:59:56.760000
2015-05-15 21:59:56.750000
2015-05-15 22:59:56.740000
2015-05-15 23:59:56.730000
2015-05-16 00:59:56.720000
2015-05-16 01:59:56.710000
2015-05-16 02:59:56.700000
2015-05-16 03:59:56.690000
2015-05-16 04:59:56.680000
2015-05-16 05:59:56.670000
2015-05-16 06:59:56.660000
2015-05-16 07:59:56.650000
2015-05-16 08:59:56.640000
2015-05-16 09:59:56.630000
2015-05-16 10:59:56.620000
2015-05-16 11:59:56.610000
2015-05-16 12:59:56.600000
2015-05-16 13:59:56.590000
2015-05-16 14:59:56.580000
2015-05-16 15:59:56.570000
2015-05-16 16:59:56.560000
2015-05-16 17:59:56.550000
2015-05-16 18:59:56.540000
2015-05-16 19:59:56.530000
2015-05-16 20:59:56.520000
2015-05-16 21:59:56.510000
2015-05-16 22:59:56.500000
2015-05-16 23:59:56.490000
2015-05-17 00:59:56.480000
2015-05-17 01:59:56.470000
2015-05-17 02:59:56.460000
2015-05-17 03:59:56.450000
2015-05-17 04:59:56.440000
2015-05-17 05:59:56.430000
2015-05-17 06:59:56.420000
2015-05-17 07:59:56.410000
2015-05-17 08:59:56.400000
2015-05-17 09:59:56.390000
2015-05-17 10:59:56.380000
2015-05-17 11:59:56.370000
2015-05-17 12:59:56.360000
2015-05-17 13:59:56.350000
2015-05-17 14:59:56.340000
2015-05-17 15:59:56.330000
2015-05-17 16:59:56.320000
2015-05-17 17:59:56.310000
2015-05-17 18:59:56.300000
2015-05-17 19:59:56.290000
2015-05-17 20:59:56.280000
2015-05-17 21:59:56.270000
2015-05-17 22:59:56.260000
2015-05-17 23:59:56.250000
2015-05-18 00:59:56.240000
2015-05-18 01:59:56.230000
2015-05-18 02:59:56.220000
2015-05-18 03:59:56.210000
2015-05-18 04:59:56.200000
2015-05-18 05:59:56.190000
2015-05-18 06:59:56.180000
2015-05-18 07:59:56.170000
2015-05-18 08:59:56.160000
2015-05-18 09:59:56.150000
2015-05-18 10:59:56.140000
2015-05-18 11:59:56.130000
2015-05-18 12:59:56.120000
2015-05-18 13:59:56.110000
2015-05-18 14:59:56.100000
2015-05-18 15:59:56.090000
2015-05-18 16:59:56.080000
2015-05-18 17:59:56.070000
2015-05-18 18:59:56.060000
2015-05-18 19:59:56.050000
2015-05-18 20:59:56.040000
2015-05-18 21:59:56.030000
2015-05-18 22:59:56.020000
2015-05-18 23:59:56.010000
2015-05-19 00:59:56
2015-05-19 01:59:55.990000
2015-05-19 02:59:55.980000
2015-05-19 03:59:55.970000
2015-05-19 04:59:55.960000
2015-05-19 05:59:55.950000
2015-05-19 06:59:55.940000
2015-05-19 07:59:55.930000
2015-05-19 08:59:55.920000
2015-05-19 09:59:55.910000
2015-05-19 10:59:55.900000
2015-05-19 11:59:55.890000
2015-05-19 12:59:55.880000
2015-05-19 13:59:55.870000
2015-05-19 14:59:55.860000
2015-05-19 15:59:55.850000
2015-05-19 16:59:55.840000
2015-05-19 17:59:55.830000
2015-05-19 18:59:55.820000
2015-05-19 19:59:55.810000
2015-05-19 20:59:55.800000
2015-05-19 21:59:55.790000
2015-05-19 22:59:55.780000
2015-05-19 23:59:55.770000
2015-05-20 00:59:55.760000
2015-05-20 01:59:55.750000
2015-05-20 02:59:55.740000
2015-05-20 03:59:55.730000
2015-05-20 04:59:55.720000
2015-05-20 05:59:55.710000
2015-05-20 06:59:55.700000
2015-05-20 07:59:55.690000
2015-05-20 08:59:55.680000
2015-05-20 09:59:55.670000
2015-05-20 10:59:55.660000
2015-05-20 11:59:55.650000
2015-05-20 12:59:55.640000
2015-05-20 13:59:55.630000
2015-05-20 14:59:55.620000
2015-05-20 15:59:55.610000
2015-05-20 16:59:55.600000
2015-05-20 17:59:55.590000
2015-05-20 18:59:55.580000
2015-05-20 19:59:55.570000
2015-05-20 20:59:55.560000
2015-05-20 21:59:55.550000
2015-05-20 22:59:55.540000
2015-05-20 23:59:55.530000
2015-05-21 00:59:55.520000
2015-05-21 01:59:55.510000
2015-05-21 02:59:55.500000
2015-05-21 03:59:55.490000
2015-05-21 04:59:55.480000
2015-05-21 05:59:55.470000
2015-05-21 06:59:55.460000
2015-05-21 07:59:55.450000
2015-05-21 08:59:55.440000
2015-05-21 09:59:55.430000
2015-05-21 10:59:55.420000
2015-05-21 11:59:55.410000
2015-05-21 12:59:55.400000
2015-05-21 13:59:55.390000
2015-05-21 14:59:55.380000
2015-05-21 15:59:55.370000
2015-05-21 16:59:55.360000
2015-05-21 17:59:55.350000
2015-05-21 18:59:55.340000
2015-05-21 19:59:55.330000
2015-05-21 20:59:55.320000
2015-05-21 21:59:55.310000
2015-05-21 22:59:55.300000
2015-05-21 23:59:55.290000
2015-05-22 00:59:55.280000
2015-05-22 01:59:55.270000
2015-05-22 02:59:55.260000
2015-05-22 03:59:55.250000
2015-05-22 04:59:55.240000
2015-05-22 05:59:55.230000
2015-05-22 06:59:55.220000
2015-05-22 07:59:55.210000
2015-05-22 08:59:55.200000
2015-05-22 09:59:55.190000
2015-05-22 10:59:55.180000
2015-05-22 11:59:55.170000
2015-05-22 12:59:55.160000
2015-05-22 13:59:55.150000
2015-05-22 14:59:55.140000
2015-05-22 15:59:55.130000
2015-05-22 16:59:55.120000
2015-05-22 17:59:55.110000
2015-05-22 18:59:55.100000
2015-05-22 19:59:55.090000
2015-05-22 20:59:55.080000
2015-05-22 21:59:55.070000
2015-05-22 22:59:55.060000
2015-05-22 23:59:55.050000
2015-05-23 00:59:55.040000
2015-05-23 01:59:55.030000
2015-05-23 02:59:55.020000
2015-05-23 03:59:55.010000
2015-05-23 04:59:55
2015-05-23 05:59:54.990000