View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Ferris
 
Posts: n/a
Default No. of days split into periods

Hi,

Here is one for you guys:

I have the following data electricity meter readings registered which I
want to split between pre-defined periods:

Data available:

15-Jan-06 78 days
30-Dec-05 300 days
14-Oct-05 200 days
30-Nov-05 45 days


Data required:

I need to split these readings into brackets and obtain the following answers:

Jan-06 Dec-05 Nov-05 Oct-05
Reading 1 15 days 31 days 30 days 2 days
etc etc

Any ideas....??

Thanks in advance
Brian