incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas S├Ąger <>
Subject Re: Copy/Pasting dates from HTML table to Calc formats wrong
Date Sat, 28 Jul 2012 08:16:23 GMT
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:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message