dd/mm in numeric format without respect to yyyyy

[amadej]

I have a long list of flowering time records (format date: dd/mm/yyyy) of a given botanic species. Time span of the records is over 30 years long. To treat this data statistically (computing average flowering time, SD, min, max, etc.) I need dd/mm (without respect of the yyyy) in numerical format - as numbers (like all records would be made in 1900 for example). How can I do this?
Sincerely
Amadej

[6StringJazzer]

If you need it displayed in that format then use a custom format of "dd/mm"

If you need text in that format then you need to add another column and use the formula =TEXT(A1,"dd/mm")

Note that original date in the example below is U.S. format.

date.jpg

[Rick Rothstein]

I am guessing that you do not want to destroy your original data, so I would suggest creating the modified dates in another column using a formula similar to this...

=DATE(1900,MONTH(A2),DAY(A2))

I am not sure what you meant by needing dd/mm in numerical format, but you can control the display using cell formatting. Either format it as "General" to see the underlying date serial number or "dd/mm" to see in that format instead.

[amadej]

Great! Thanks to both. Rick's formula calculates exactly what I wanted (however, after replacing commas with semicolons). It transposes flowering dates in any year onto the year 1900. These data can be further manipulated by statistical formulas. The display format is irrelevant.
Amadej

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.