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