Download Excel Examples - Working with dates in Excel

This is the first of a series of blog posts where we show you how to perform some common tasks in Excel - and spreadsheets in general - by providing you with downloadable examples of formulas.

The downloadable Excel example included in this blog post covers working with dates in Excel and will show you: 

  • the Excel formula to show today's date
  • the Excel formula to show yesterday's date
  • the Excel formula to show the date ten days from today
  • the Excel formula to show the day of the week that relates to tomorrow's date
  • the Excel formula to show today's date, in dd/mm/yy format, 'As at' prefix
  • the Excel formula to show today's date, dd mmm yyyy format, 'As at' prefix
  • the Excel formula to show the number of days between two dates
  • the Excel formula to show the number of weekdays between two dates
  • the Excel formula to show the first day of this month
  • the Excel formula to show the last day of this month

The fomulas provided can, or course, be edited to better suit your own purposes. But they work as is and will help you to understand how to work with dates in Excel.