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...
| +309 | UBS in Shambles as Proposed $100k H1B Fee Looms | 67 | 5d |
| +105 | I think I’m logging off after ER visit | 21 | 4d |
| +97 | Article: UBS Quietly Hollowing Out Its Onshore Workforce and Rebuilding the Bank in India | 25 | 5d |
| +91 | Fitting In as a first gen | 28 | 1d |
| +81 | Is it Bad That I ALREADY Don’t Care? | 24 | 1d |
| +52 | Consulting Son or CorpDev Daughter? | 6 | 3d |
| +50 | AI Creating More Work | 15 | 1h |
| +50 | Senior Banker's Guide to IB Recruiting / Group Placement (with a Healthcare Bent) | 6 | 7m |
| +45 | Shit PWP Culture | 32 | 2h |
| +44 | How easy was recruiting for you? | 21 | 3d |
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
Recusandae tempore officiis et voluptate eveniet. Ipsum voluptatem praesentium est numquam est libero. In assumenda ut modi asperiores.
Placeat quas cumque voluptas esse laboriosam rem. Consequuntur dignissimos consectetur at quam. Debitis ut eius iusto non ducimus.
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...