• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Interactive Data range formula

C

cocabaldi

New Member
Hello everybody,

first time in this great place, thanks chandoo!!

I worked in IB, once I saw an amazing formula which worked like this:

starting year: 2015
projection years: n (let's say 10)

and automatically created an array of dates, from 2015 to 2025, it was pretty simple and working mainly with if and.

can you help me to reproduce anything similar? then my spreadsheet will look even better :)

thank you
paolo
 
I meant that the formula I'm looking for, automatically populate the cells (where is written) with proper year progression otherwise shows 0.

starting year: 2015
projection years: n (let's say 10)
 
thanks for reply, but I don't quite get it.
I'll try to be clearer:

2 inputs:
g99: starting year: 2015
f99: forecast up to (number of years): 15

in h99 i'd like to insert a formula which automatically populate cells up to 2030 (2015+15) and shoes empty cells afterwars.
 
Hi ,

See the attached file.

There are 2 formulae which have been used ; use which ever one is suitable for your requirement based on whether you wish to populate cells in a row or in a column.

Narayan
 

Attachments

  • Book1.xlsx
    12.2 KB · Views: 8
Hi ,

In Excel , all dates are numbers ; the format merely decides how these numbers are displayed.

For example , if you enter a number such as 42300 , formatting it as a date will display it as 10/23/2015 , 23-10-2015 , or even Friday, October 23, 2015 depending on the format chosen.

The formula itself does not need to change , unless you want the dates as text.

Narayan
 
You must log in or register to reply here.
Back
Top