About this document
Excel Advanced Date Functions Guide by Soumitra Chakraborty is a document available to read on EtoBox.
This document provides instructions on how to use several Excel date functions including DATEDIF, WEEKDAY, TEXT, NETWORKDAYS, WORKDAY, and DATE. It demonstrates how to calculate the number of days, months, or years between two dates, return the day of the week of a date, calculate holidays and weekends between dates, and return the date before or after a specified number of weekdays. Examples are given for creating a timesheet, finding the last day of the month, calculating days until a birthday, and more.
- Author
- Soumitra Chakraborty
- Language
- EN