August 2005 archive

mc (on linux) and putty (on windows) view chars and lines problem

1) edit /usr/share/mc/bin/mc−wrapper.sh 2) add only BLUE lines: …….. MC_PWD_FILE=”${TMPDIR−/tmp}/mc−$USER/mc.pwd.$$” SAVE_LANG=”$LANG” export LANG=”C” /usr/bin/mc −P “$MC_PWD_FILE” “$@” export LANG=”$SAVE_LANG”

Excel – Calculate Age (Years, Months, Days BETWEEN 2 DATES)

=DATEDIF(a1; a2;“y”) OR DATEDIF(a1, a2,“y”) :   (; or ,) ============================================= — =DATEDIF(A1;A2;”y”) & ” years, ” & DATEDIF(A1;A2;”ym”) & ” months,” & DATEDIF(A1;A2;”md”) & ” days” — OR — =DATEDIF(A1,A2,”y”) & ” years, ” & DATEDIF(A1,A2,”ym”) & ” months,” & DATEDIF(A1,A2,”md”) & ” days”