Hi Experts,

Need some help on this request.

Previously, did saw a [solved] thread for this.
http://www.excelforum.com/excel-form...-workweek.html
The excel formula used was: =CEILING(INT((A2-TIME(19,,)-DATEVALUE("2jan2014")))/7,1)
This only executed for the date but not inclusive of the time to return the workweek.

My current new request need the excel formulae to take into consideration of the "mm/dd/yy hh:mm" to convert it to workweek.
Book11.xlsx

Any form of help is greatly appreciated!

Regards,
hate0lif3