Retaining Data after condition change

P

phocused

Apologies for reposting this

Hi,

Can anyone help with this? I still think it can be done... I just need some
Genius to show me how:) Heres the problem, in the question below you will
see what i am trying to acheive.
I want to count by day/month (see Bobs formula) the number of entries that
are still open at the end of each month, in other words the end date is not
set. However when the end date DOES get set, I want to retain the retain the
historcal data. Is there any way to have my pie and eat it?

Ref Start End Jan Feb Mar
Apr.........>>

12321 23/01/06 1 1 1

then when the end date is added I still want the Jan - Mar data retaining

Ref Start End Jan Feb Mar
Apr May
12321 23/01/06 23/04/06 1 1 1
0 0

At the moment it fills Jan Feb and Mar butr as soon as I add the End date it
Zeros the historical data.

Rgds Paul
phocused said:
Bob, worked a dream, thanks, I may need to rethink how i do this however.
Having applied your formula I realised that it records the data as required
however once i enter an end date in B2 all data for the previous months and
zero it. This means i end up with no historic data telling me how many calls
were opened by month.

i'll have a thnk about it. but again

Many thanks for your help.

Rgds Paul
Click to expand...
Was this post helpful to you?

Why should I ra
 
Top