Tuesday, November 17, 2009

EXCEL - Date & Time format

Date & Time
=(DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())) + TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())))

Calculate working days different between two dates
=NETWORKDAYS(startdate, enddate)
Posted by ricky at 7:14 PM
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)