You can create a macro to open a CSV file. One problem you may face is that dates are treated as US dates. A simple change can fix this.
Excel has had a week number function for many versions, but Excel 2013 added a new week number function that complies with the ISO 8601 standard week number.
When working with loans or leases, it is common to have to add a number of years to a start date to determine the end date. An Excel function can automate that process.
If you want to place ordinals (st, nd, rd and th) after a number in a date. You can use the CHOOSE function to do this.
Date data imported from other systems can include times. This can make lookup and other calculations difficult. One function can make removing or extracting time easy.
When you use date grouping (by months) in one Pivot Table report it affects other Pivot Table’s date reporting from the same data. There is a work around to allow you to have daily, monthly and quarterly Pivot Table reports.
The WEEKDAY function allows you to convert all dates into a number from 1 to 7 representing their weekday, from Monday to Sunday.
You don’t have to use an IF function to get the most out of logic calculations in Excel.
The Australian Financial Year runs from 1 July to 30 June. To determine which quarter a date falls into there are at least a couple of formulas that will do the trick.
In Australia our financial year is from 1 July to 30 June. If you need to work with days elapsed or days remaining in the financial year you can use a few formulas to do the calculations for you.
Ever needed to convert the text Sep or September into a 9? Well Excel can convert text months into their respective numbers.
Sometimes when you import data via a CSV (Comma Separated Values) file or a TXT file, the dates don’t always import very well.
Entering today’s date in Excel can be done a couple of ways. It depends on whether you want the cell to always show the current day’s date or whether you want to capture today’s date so that it doesn’t change.
I installed Excel 2013 last week and have had a bit of play.
Note: you need Windows 7 or later to run Excel 2013.
The DATE function allows you to easily add or subtract, months or years from dates. The DATE function can also convert any date to the last day of the month or the first day of the month. This can be very useful when working with date ranges.