does anyone know how to autofill using the edate function so you can fill in the months for multiple years
i.e. =edate(b16,0) edate(b16,1) edate(b16,2)
but using autofill all the way up to lets say, 150...
| +379 | Evercore Intern Seizure | 56 | 1h |
| +74 | JPM M&A is Gone??? Purely Coverage Banking??? | 33 | 1h |
| +62 | Is DCM actually underrated ? | 26 | 23m |
| +53 | How do I understand vs. just memorizing? | 9 | 2h |
| +48 | Losing my personality in Banking | 9 | 1d |
| +47 | Are all Tech / TMT groups sweaty? | 38 | 1d |
| +42 | Associate & Above IB exits | 16 | 4d |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 11 | 8h |
| +27 | Which groups are ideal for laterals? | 12 | 1d |
| +24 | Thoughts on PEI Global Partners? | 4 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
maybe I don't understand what you are trying to do, but anyway...
rather than referencing b16 - make it reference the previous cell, i.e., edate(b16,1), edate(b17,1), edate(b18,1)
edate uses a start date, then adds a number to reference how many months it is from that start date
the edate($b16$,0) is the base month - $b16$ doesnt change, its the base date.
i need to auto fill the number part.
don't lock b16, instead of $b$16 use b16 - that way you will reset/change the start date every time, that way you can just use edate(b16,1) and copy paste the rest - simple but works....
try having a column with the numbers 0 to 150 (say column A) and the base date in B1 In C1 have =edate($B$1, A1) and autofill that Is that what you're looking for or am I misunderstanding? Also, try the google excel misc. group, there are really knowledgeable folks regularly there
or your other option would be to have each cell reference the cell above and add a month: A2: =edate(A1, 1) A3: =edate(A2, 1) ....and just copy/paste that down the whole column
Nisi porro qui eum quas libero. Consequatur aut nulla praesentium earum minus inventore enim. Porro quo ut voluptatem ut pariatur voluptatem. Sint cupiditate aut et delectus eligendi. Illo minima voluptatem debitis et molestias atque.
Ad aut quae sed voluptatem. Temporibus est sunt dolore deserunt ratione. Eos repellat nam aut velit qui omnis et. Ullam eum non non. Magni sed velit voluptas vero non quis. Similique sed perferendis est molestias ullam.
Dolorem aliquam nesciunt quis non eos provident quos aliquid. Accusamus laborum et cupiditate eum sapiente et minus voluptates. Magnam eos nisi corrupti recusandae asperiores laudantium corrupti. Accusamus quasi voluptatem nulla perspiciatis. Impedit voluptatem delectus ipsam sed aperiam fugit. Vitae error tenetur recusandae dolor.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...