I need help with a formula please

Hi there,

I get send budgets for a whole month. Cell D10 might be my Gross Profit value and D11 might be my target value. These cells belong to a day, lets say the first of the month. As with every month the 1st might be on a friday or even a monday depending on the month. That means D10 might refer to Gross Profit on the 5th of the months but in other months D10 might be a Gross Profit value from a differnent day.

What I was wondering is, is there a formula that can find the value of a date? Can a cell look for a day number and then give me the value of that cell?
The months are always typed as 1/02/2005 format so can I get a cell to refer to a value from a cell that start with "1/".

Hopefully you'll understand what I mean

Instead of looking up for "1/", you could use the worksheet function
=DAY(A1)
where cell A1 is the concerned date. The above function returns the day for e.g. in your case, if the date is 1/02/2005 (1-feb-2005), then the above function returns 1.

- Mangesh