Principles of Financial Modelling

CHAPTER 23Date and Time Functions

INTRODUCTION

This chapter covers functions in Excel's Date and Time category, including:

• DATE returns the serial number of a date, corresponding to a specified year, month and day.
• DATEDIF calculates the age in a unit, i.e. number of days, months or years between two dates.
• DATEVALUE converts a date in the form of text to a serial number.
• DAY converts a number to a day of the month.
• DAYS returns the number of days between two dates.
• DAYS360 calculates the number of days between two dates based on a 360-day year.
• EDATE returns the number of the date that is the indicated number of months before or after the start date.
• EOMONTH calculates the number of the last day of the month before or after a specified number of months.
• YEAR converts a number to a year.
• MONTH converts a number to a month.
• WEEKDAY converts a number to a day of the week.
• HOUR converts a number to an hour.
• MINUTE converts a number to a minute.
• SECOND converts a number to a second.
• TODAY returns the number of today's date.
• NOW returns the number of the current date and time.
• TIME returns the number of a time.
• ISOWEEKNUM returns the number of the ISO week number of the year for a given date.
• WEEKNUM represents the week number of a date within the corresponding year.
• NETWORKDAYS returns the number of whole workdays between two dates.
• NETWORKDAYS.INTL returns the number of whole workdays between two dates using parameters to define weekends.
• TIMEVALUE converts a time in the form ...