I am using in cell c2 the following formula =Date(Year(Currentdate),Month(CurrentDate),0)
And getting 31 March 2011 as the returned result
When I need today's date
And in cell b2 I have =Date(Year(c2),month(c2),0) and so on for a2
What's wrong here??