Loading...

Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

573,760 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 21, 2011

Download file: https://people.highline.edu/mgirvin/E...
1. DAY function
2. TEXT Function to get Day spelled out, like "Monday"
3. TEXT Function to get Month spelled out, like "January"
4. MONTH Function
5. YEAR function
6. Last Day in Month: EOMONTH function
7. Last Day in Month: DATE, YEAR, DAY, MONTH functions
8. First Day Next Month: EOMONTH function
9. First Day Next Month: DATE, YEAR, DAY, MONTH Functions
10. Vest Date: EDATE function
11. List of First Day in Month: EOMONTH
12. WORKDAY function -- find workday in future given a certain number of days.
13. WEEKDAY function
14. Last Monday: DATE, YEAR, MONTH, DAY and WEEKDAY functions
15. Formula for Days Between Two Dates
16. Formula for Days Between Two Dates, Inclusive
17. Net Working Days with NETWORKINGDAYS Function

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...