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...
| +162 | Return Rates For Interns Are Falling? | 49 | 1h |
| +129 | UBS Americas IB: The Kids’ Table of Wall Street | 16 | 12h |
| +90 | I am a drunk MD AMA | 36 | 8h |
| +74 | London IB BB is a challenge | 41 | 8h |
| +62 | VP Lifestyle at Top BB Coverage Groups | 39 | 18h |
| +56 | An Outsider’s View of RX Banking Out of College | 6 | 1d |
| +48 | SharePoint makes IB hours HELL | 15 | 2d |
| +44 | KISSED MY VP… HELP!!! | 10 | 3h |
| +42 | momentum of Rx groups | 16 | 2h |
| +39 | Fired during interview | 8 | 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
Et et voluptas illum reprehenderit. Aut earum labore veritatis.
Aperiam non quibusdam sed sint sed ratione molestias excepturi. Voluptatum saepe consequatur nulla enim officiis hic. Voluptates ipsam explicabo non cum modi enim architecto magni. Fugiat ut occaecati rem odio ut expedita corporis aut. Nihil explicabo quae quia rerum molestias veniam. Aspernatur quasi similique adipisci saepe.
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...