Description
Excel date functions
Understand how handling excel date functions can halve the time you spend working on them!
Learn to use the special tools that have been included in Excel to handle dates!
By reading this book and doing the you will learn
- How Excel treats dates
- How to get the day, month and year our of dates
- How to convert the format of dates so that excel recognises the difference between American style dates and other formats
- How to calculate working days, days of the week, and other useful date tips, tricks and warnings
Excel Date Questions Answered
- Understanding Dates in Microsoft Excel
- How do I know if Excel recognizes my date?
- 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