PDA

View Full Version : Excel formula



bpt2
21-03-2007, 04:21 PM
I have two columns, one of dates and one of associated balances. I want to extract the balances (and their dates) associated with the first date (not necessarily 01) in each month for charting purposes. Anyone got an idea?
Thanks

Parry
21-03-2007, 05:36 PM
Hi, not sure if I understand what you mean but if your wanting to select values based between dates then assuming A2 has the date and you want records between 22/3 and 24/3 then put this in a separate column and anything with True means it meets your criteria...

=AND(A2>DATE(2007,3,21),A2<DATE(2007,3,25))

wotz
21-03-2007, 06:44 PM
Haven't checked Parry's answer but think I understand the problem. It sounds like a list of bank balances or similar, with a row for each date. These dates would be bank processing dates, so will not have every day - if the 1st is a Sunday, the 1st entry for that month is the 2nd. The chart is to show the balance on the 1st row of every month.

bpt2
22-03-2007, 04:45 PM
That's probably the best way of describing it as I don't necessarily know the date range.