Excel Date and Time
Dates and times can be hard to get to grips with for newcomers. However, this list of Excel date and time tutorials will give you a head start.
- Return End Of Month Date with =DATE
- Forcing Dates Forward
- Calculating the Number of Days Between Two Dates
- Determining Whether a Worked Shift Was Morning, Afternoon or Night
- Adding Time Values from Separate Hours and Minutes Columns
- Week Number (WEEKNUM)
- Determining Whether a Person Worked a Full or Partial Shift
- Holiday – M.L. King
- Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)
- Method to Determine Whether a Year Is a Leap Year
- Converting a Date into a String, Indicating the Quarter Number and Year
- Formatting Time Values
- XL2001: How to Use Dates and Times in Microsoft Excel
- Find the elapsed time between two time entries
- Dates -Number of days in a month
- Get Weekday Occurence
- Finding the maximum value of all those meeting a certain criteria.
- Indicating Due Payments, Based on the Current Date
- Detect Leap Years
- ISO Week Count