Dates

Work

How To Convert Dates Between Australian & US Formats In Excel

Flag
1:00PM March 21, 2011 | Angus Kidman

If you’ve got a bunch of dates in US mm/dd/yyyy format and need to convert them into Australia’s dd/mm/yyyy format (or vice-versa), it can be hard to know where to start. Office expert Helen Bradley details how you can work through that process in Excel. More »


Organise

Use Wolfram Alpha To Find What Day A Given Date Was

Flag
10:00AM October 13, 2010 | Angus Kidman

Another handy use case for Wolfram Alpha: enter a date such as September 8, 1980 and it will immediately tell you it was a Monday. More »


Work

Find The Number Of Mondays Between Two Dates

Flag
3:00PM April 6, 2010 | Angus Kidman

Working out the number of Mondays in a month isn’t too hard. Working out how many fall between two dates is trickier. The Mr Excel video series offers two ways to get that task done automatically with a formula. More »


Organise

Quickly Navigate Your Calendar To Find The Day Of Any Given Date

5:30AM June 17, 2009 | Adam Pash

Ever wonder what day of the week your 40th birthday will land, even if it’s some 12 years out? Turns out Windows 7 and Vista’s handy system tray calendar makes navigating future and past dates a breeze. More »