|When you say "I want to work with only the day date and monthly date. mm/dd" do you mean that you want Excel ignore the year (e.g. 11/25/2008 is equivalent to 11/25/2010) or do you mean that you just don't want Excel to display the year, but still retain it for date related calculations, etc.?|
I guess is all depends on what you plan to do with the result.
With 11/25/2008 in A1 this will display 11/25, but it won't be a date anymore, it will be text:
=MONTH(A1) & "/"&DAY(A1)
With 11/25/2008 in A1, this format will display 11/25 and the date will still be a date, it just won't display the year.
Finally, if you need it to be a date, but don't care if every Month/Day has a year of 2010, try this:
With 11/25/2008 in A1, use:
=DATEVALUE(MONTH(A1) & "/"&DAY(A1))
Every "date" set up like that will have the current year associated with it, e.g. 2010