Excel Fill Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to fill a column with variable starting and ending dates. I am using the Fill / Series Function but I cannot input a cell in the Stop Value. Any suggestions
Thanks
Lisa
 
What are you trying to do (meaning what is it for)?
You would need to use formulas, here's an example assuming that you
put the first date in A1, put the formula in A2, format as date and copy
down to
A31

=IF(A1="","",IF(DATE(YEAR(A1),MONTH(A1),DAY(A1))=DATE(YEAR(A1),MONTH(A1)+1,0
),"",A1+1))

if you always want 31 days from the date you put in you can use this in A2

=IF(A1="","",A1+1)

copy down

--

Regards,

Peo Sjoblom

Lisa said:
I am trying to fill a column with variable starting and ending dates. I
Click to expand...
am using the Fill / Series Function but I cannot input a cell in the Stop
Value. Any suggestions?
 
Especifically, what I want to do is if in cell A1 I have a year, say 2004, I want to populate several forms with two years worth of dates, day-by-day

I really appreciate your help
Lisa
 
Back
Top