Am 26.07.2012 16:18, Art Scheel wrote:
I am attempting to copy table data where 2 adjacent columns are dates. MM/DD in one, YYYY in the next. Obviously these are 2 separate fields.
=DATE(B1;MONTH(A1);DAY(A1)) calculates the date A1 but in the year B1.
When pasting into OOo Calc 2.4.0, it formats the date in the first date column by assuming the year is 2012. Some of those date fields indicate a date range such as 03/17-18 (March 17 through 18). These get interpreted as 03/17/2018 by OOo.
Of course. This is a simple calculator with no built-in artificial intelligence. Information on the web-page is made up for human readers.
This tries to handle both cases, ignoring the second day, assuming 2-digit month and 2-digit day: =IF(ISNUMBER(A1) ; DATE(B1;MONTH(A1);DAY(A1)) ; DATE(B1;VALUE(LEFT(A1;2));VALUE(MID(A1;4;2)))
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
