|
|
|
|
BOOK DOWNLOAD: Excel Dates- Halve your work day
SKU
HOW_TO_WITH_EXCEL_DATES
Excel Date Questions Answered
|
|
|
Content (50 pages)
- Understanding Dates in Microsoft Excel
- How do I know if Excel recognizes my date?
- Option 1
- Option 2
- Option 3
- Extract a DAY from a date
- Extract a MONTH from a date
- Extract a YEAR from a date
- Create a valid excel date with the day, month and year information
- How to find the last day of the month, even in leap years
- How to determine what day of the week a date represents
- How to determine when the next working day is
- How to determine the number of working days between 2 dates
- How to count the number of days, months or years between 2 dates
- How to CONVERT dd/mm/yyyy to mm/dd/yyyy and vice versa
- How to CONVERT 20100925 into a valid excel date
- How to CONVERT 2010.09.25 into a valid excel date
- How to CONVERT any date style into an excel recognised date
- How to convert an Excel date into a 'special' format for uploads e.g.2010.12.25
- How to Enter the current Date and Time easily into a cell
- How to find new formats for dates (and time)
|
|
- How to find new formats for dates (and time)
- Why should I be careful about dates past 2030
- Why do some of my dates have a green note warning about entering 2 digits
- How to group Pivot Table dates into years, quarters, months, days etc
- Why does my Pivot Table not recognise my dates
- How do I get a pivot table to show me all the dates in a sequence, even the dates with no data
- How do I get a year and a month in the horizontal axis of a graph
- How can I control what dates are entered into a cell
- How can I change the colour of cell if a date exceeds a reference date
- What does a #value mean when looking at a date
- How to set up a time format so that it adds the hours past 24 hours
- How to force Excel to see a 'date' as a date
- How to determine the fraction of a year between 2 dates
- Thinking through Date Problems in Excel
- How to escalate income based on periodic, date based escalations
- How do I check if a year is a leap year
- How to determine the last weekday of any month
- CTRL Shortcuts
- How to easily access every function/ formula in Excel
|
In Excel terms you will learn the following functions and tools:
WEEKDAY, EOMONTH, DATE, DAY, MONTH, YEAR, Custom Formats for dates, Convert from US (mmddyyyy) to European format (ddmmyyyy), DATEDIF, WORKDAY, NETWORKDAY, CELL, DATEVALUE, YEARFRAC.
Note that this is a download only.
|
|
|