Split Sheet By Date

Split Sheet By Date command lets you split a sheet into separate sheets based on the value of a date column.

You can split the sheet by year, month, day, day of week or week number of the year.

Example

  • Open Easy-XL's Sample Workbook
  • Select the Invoices Sheet
  • Select Split Sheet By Date from the Easy-XL Menu
  • In the Split Sheet By Date dialog box, select the period of time you wish to isolate: either day, week, day of week, month, or year. For this example select Month.
  • Click Finished.