Using a date range in a formula to pull info to the correct co
Biff,
I have them labeled as January, February, etc... the other columns are Cost
and Date Billed.
Thanks
"T. Valko" wrote:
How do you have your 12 columns for the months identified? A date like
1/1/2007, 2/1/2007, 3/1/2007? A *TEXT* heading like Jan, Feb, Mar?
Biff
"Tricia" wrote in message
...
I have a spreadsheet set up with a column (a) with cost; (b) bill date and
12
columns for each month. I need a formula that will pull (a)the cost into
the
correct month column based upon (b)the bill date which would be within the
range 1/1/07-1/31/07, etc for each month.
I tried so many different formulas but non seem to work...
=if (b) =1/1/07&1/31/07, (a),0
|