Forum Discussion

Johns_Corner's avatar
Johns_Corner
Copper Contributor
Apr 02, 2020
Solved

Need help how to do this

I don’t know how to explain it so here is a screenshot of what I want to happen
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 02, 2020

    Johns_Corner 

    If you are on Excel with dynamic arrays that could be

    with

    =EDATE(C5,SEQUENCE(C2/C3)-1)

    and

    =SEQUENCE(C2/C3,1,1,0)*C3

    and assuming division of number on average returns integer.

Johns_Corner's avatar
Johns_Corner
Copper Contributor
Apr 03, 2020

Thanks for your replies.  Here is what I did.

 

Resources