Cumulative days calculation in a time series

N

Nick Marmont

Can anyone help me to create a series which gives
cumulative days since a start date?
i have a series of data whaich comprises dates over many
years, irregular intervals, and I want to create a series
which gives cumulative days since start date. I cannot
copy and paste the A3-A1 formula because the formula
changes with each new cell....
 
N

Nikos Yannacopoulos

Try formula A3-$A1... this will keep A1 constant as you
copy down.

Nikos
 
N

Nick Marmont

A BIG Thank you to both of you!! you can spend hours
looking for things like this... I did - and still not
find the answer!

THANKS!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top