When creating date series in an Excel Column, usually one has to pre-calculate the number of rows that would be needed to populate the dates.
With this Hack, all that is history, Excel takes care of it all. All one is required to do is to enter the Start data and then the End date and Excel would populate the rest. No need to struggle with your mouse to determine the number of rows that may be needed.
In under a minute I would show you how this is done!