Welcome to AspAdvice Sign in | Join | Help

EXCEL - Simple Date 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)

Published Wednesday, November 18, 2009 11:03 AM by mo meng

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
required 
(required) 
Enter the code you see below