Re: Date format

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David McRitchie (dmcritchie_at_msn.com)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 07:45:37 -0400

Hi Jimmy, (correction to my previous reply reposted in microsoft.public.excel)

Depending on which side of the 1900 or 1904 date system you are
on add or subtract 365*4 - 1

If these are constants then you can...
You can do that by placing 1459 in a cell, selecting it, copy (ctrl+c),
select the column to be corrected,
edit, goto, constants an number (no you've select only number constants)
edit, paste, special, add or subtract 

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm
=>
> "Jw" <jwhk3@hotmail.com> wrote in message news:%231iygVahEHA.3664@TK2MSFTNGP11.phx.gbl...
> > hi, david
> >
> > thank for your email
> >
> > in fact, i used daceasy version 11 accounting software to export the data in
> > excel 5.0 format (file a) and then i used a vlookup function to match (file
> > b which is manually inputted by me).
> >
> > what can i do ??

Relevant Pages

  • Re: Date format
    ... select the column to be corrected, edit, paste, special, add or subtract ... David McRitchie, Microsoft MVP - Excel ... >> Hi Jimmy, ...
    (microsoft.public.excel)
  • Re: Excel Cell Format???
    ... Correction use ... David McRitchie, Microsoft MVP - Excel ...
    (microsoft.public.excel)
  • Re: convert time in xxxx format to xx:xx
    ... If you subtract your 00:51 ... If you are unfamiliar with how to create a VBA macro and then execute ... With Excel running, hit ALT-F11. ... This opens the VBA editor. ...
    (microsoft.public.excel.misc)
  • Re: Function returning unexpected value
    ... subtract "baseline planned date", presumably the part of the IFexpression ... Indeed, if the cell containing "actual completion date" is empty, which is ... Excel provides some tools for debugging formulas. ... Alan Moseley IT Consultancy ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Formulas - Excel
    ... You can use SUMIF on Sheet2 to sum number of items sold by type on Sheet1. ... You can subtract that from the total to get the availability. ... Should I use Excel? ...
    (microsoft.public.excel.misc)