Month Formula

[BenT]

Hi All,
I need a formula;
A1:M1 have months, Jan...Feb...March...etc.
A2:M2 have dollar amounts,
I need to fill A3:M3 with these dollar amounts only if it is the current month.
The remainder of the cells from A3:M3 to remain unfilled.
Thanks
Ben

 

[Mike H]

The formula may be useful

=IF(MONTH(TODAY())=MONTH(A1),A2,"")

 

[Mike H]

On the assumption you have jan etc in Row 1 formatted properly try this in A3
and drag right

Mike

 

[BenT]

Mike
I thank you very much, it drove me crazy, with your help I done did it,
Thanks, Ben
On the assumption you have jan etc in Row 1 formatted properly try this in A3
and drag right

Mike