Excel Unplugged

Tag Archives: Fill and Series in Excel

Create a Date Series of all weekdays in Excel (omits Saturdays and Sundays)
  • December 9, 2014

      Let’s say we want to create a series of dates from 1/1/2013 to 12/31/2013 but with a catch. We want to leave out all dates that occur on weekends. So all ...

    Create a Factor Growing Series in Excel

    If someone was to tell you, do a 1;2;3;4;5;6;7;8;… series in Excel, there are many that would not hesitate and go for one of the two options Write 1 and 2 in the ...