hello all

[spk1009]

I have a challenging excel question...

For instance, I have a starting month of 6/1/2012 in cell A1, and an annual revenue amount in A2. In cells B2:M2 (12 months- Jan - Dec respectively), populate ONLY the remaining months from date in A1 with formula =($A$2/12).


So my ultimate goal is to have cells H2:M2 populated with results from formula =($A$2/12).


thank you.

 

[Luke M]

How's this?

=IF(COLUMN()-1>MONTH($A$1),$A$2/12,"")

 

[spk1009]

What is the column() represent?


thanx!