edate in excel
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...
Trending Content
| +278 | Looking to raise a Billion Dollar Fund - College Junior | 41 | 16h | |
| +225 | It doesn’t need to be this way | 31 | 52m | |
| +173 | What to expect during your IB summer internship and how to secure the full-time offer | 9 | 3h | |
| +140 | Biggest gripe in IB: people with no balls | 38 | 5h | |
| +136 | Career Bankers, Was It Worth It? | 45 | 11h | |
| +89 | RBC M&A vs PJT RSSG | 14 | 2d | |
| +81 | I FINALLY DID IT, I GOT A FT OFFER! | 14 | 17h | |
| +79 | MD Can’t Unplug | 24 | 2h | |
| +63 | Did I mess up by correcting my VP Publicly? | 20 | 1d | |
| +57 | BofA Assoc who died had sought to leave, citing long hours | 15 | 2h |
Career Resources
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 dolores consectetur molestiae quo ut voluptatibus. Qui nemo totam reiciendis sed. Aut unde maiores minima quo reprehenderit. Et omnis natus consectetur ab voluptatem a est. Aliquam quia voluptates quia est ducimus cum eos.
Quis voluptatem et temporibus consequatur sit maxime maiores. Eius sapiente reprehenderit minus voluptatem et enim assumenda. Sint doloremque suscipit molestias deleniti vitae. Corrupti mollitia sequi inventore sequi quisquam qui. Incidunt aut velit dolorum labore voluptas.
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...