Home
| Calendar
| Mail Lists
| List Archives
| Desktop SIG
| Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings Linux Cafe | Meeting Notes | Linux Links | Bling | About BLU |
I have a spreadsheet maintained by someone on Windows. The sheet must calculation a difference in years between 2 dates. Example (OpenOffice): A1 = 06/04/2002 B1 = 07/04/2007 B2 = =DATE(YEAR(B2); MONTH(B2) + 1; DAY(B2)) Replicated down through B69 C2 = =YEARS($A$2;$B2;0) Replicated down through C69 In Excel, the formula in C2 (and following) is: C2 = =DATEDIF($A$2;$B2;"y") The problem is that OOo does not recognize the DATEDIF function and Excel does not recognize the YEARS function. Both work well, but in my work environment, the spreadsheed is maintained on someone else's Windows laptop, but my work environment is Linux on a corporate server (RHEL 4). I don't want to install MS office and Crossover office on these servers. Since I'm only dealing with 3 instances on a fairly complex spreadsheet, I can live with making the changes whenever the spread sheet is changed, but I would like to find a function common to both. -- Jerry Feldman <[hidden email]> Boston Linux and Unix user group http://www.blu.org PGP key id:C5061EA9 PGP Key fingerprint:053C 73EC 3AC1 5C44 3E14 9245 FB00 3ED5 C506 1EA9 _______________________________________________ Discuss mailing list [hidden email] http://lists.blu.org/mailman/listinfo/discuss
BLU is a member of BostonUserGroups | |
We also thank MIT for the use of their facilities. |