| Home : September 14 2016 Computer News : Mastering Excel Date & Time: Date, Days, Days360, Time, and Weekday |
|
Mastering Excel Date & Time: Date, Days, Days360, Time, and Weekday |
September 14, 2016
Last week I explained how Excel uses its own, unique system of serial numbers to calculate dates and times. That piece covered nine Date & Time functions: NETWORKDAYS(), DATEVALUE(), NOW(), DAY(), MONTH(), YEAR(), HOUR(), MINUTE(), SECOND(), plus the basic SUM function for adding and subtracting start dates and end dates.This week I’ll explain how to use seven more Date & Time functions: DATE(), DAYS(), DAYS360(), TODAY(), TIME(), TIMEVALUE(), and WEEKDAY().DATE()
Go to cell A5. From Formulas > Function, select Date & Time. In the drop-down list, select DATE.To read this article in full or to leave a comment, please click here
Link: http://www.pcworld.com/article/3075848/software/mastering-excel-date-time-date-days-days360-time-and-weekday.html#tk.rss_howto
|
|
|
|
|