View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MorningCalm MorningCalm is offline
external usenet poster
 
Posts: 3
Default How to get individual dates from a date range

Hi,
I have 2 columns, one Start Date and the other End Date.

I want to display all the dates that fall in between the above range.

For e.g.
Start Date End Date
01/01/2006 05/01/2006

I want excel to give me the result as
01/01/2006
02/01/2006
03/01/2006
04/01/2006
05/01/2006