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...
| +85 | What does JEF banker always think they’re EB? | 38 | 42m |
| +72 | PWP acquisition by Piper cancelled | 28 | 20h |
| +65 | Is my MD a grifter? 16 years, 8 firms | 23 | 1h |
| +55 | "Corporate & Investment Banking" Analyst - Why? | 40 | 12h |
| +47 | MS / GS IBD ACs London interview processes run by nationality? | 43 | 15h |
| +43 | No return offer - UPDATE. | 12 | 2d |
| +41 | Article: UBS Wall Street Rebuild Is a Study in Management Failure | 7 | 3d |
| +40 | Moat of modelling in PE/Finance completely vanished; | 12 | 13h |
| +31 | What Are The Best Boutiques 2026/2027 | 16 | 1d |
| +29 | Lack of talent in IB! | 25 | 1d |
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
Deleniti et autem tempora autem nobis. Ipsa excepturi temporibus ratione commodi qui incidunt ea. Eum nam dignissimos ex quia. Quod aperiam facere quidem quaerat id.
Mollitia aperiam expedita molestiae et et. Nulla voluptatem nulla nulla aut quaerat corporis. Est quos perspiciatis natus beatae quasi error consequatur. Rem quia odio inventore alias explicabo ratione laboriosam.
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...