One way ..

Assuming the reference date is entered in A1, eg: 21-Dec-2006

Place in say, A3:
=IF(DATE(YEAR($A$1),MONTH($A$1),ROW(A1))$A$1,"",D ATE(YEAR($A$1),MONTH($A$1),ROW(A1)))

Copy A3 down by 31* rows to A33
*to cater for the maximum days per any month of the year

A3:A33 will return the required results,
ie an auto-fill from the 1st till the date entered in A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"noyau" wrote:
I cant find the way out. I have a daily variable data in a single cell (say
in A1) ant I want to form a serie with using daily values of that cell.

(Variable)
Date Value
21.12.2006 400

(Series)
01.12.2006 300
02.12.2006 350
...
...
20.12.2006 420
21.12.2006 400