column list of dates, average random cells

Assuming the dates are sequential - enter the first date in the first cell... then thereafter increment by adding 1 to the prior cell value (dates are integers), eg

A1: TODAY()
A2: =A1+1
copy down

Re: 2nd question

=AVERAGE(A1,A10,C1:C4)

so enter AVERAGE(
then navigate and click the ranges you wish to include)
once completed add a )
(you will get a DIV/0 if none of the selections contain numerical values)

Originally Posted by kufram

Hi all

I want to make a column with the date of each day in a cell. do i have to type them all in? Any ways to avoid this?

Also, I want to select various cells in a spreadsheet and make a cell display their average. I can average a column or row, but can't average a random selection of cells. Impossible?

Please do not post the same question in multiple forums