Re: Creating/Calculating Lapsed Time

Hi Phil,

That might work for Excel, but not for Word - which is what the OP is using.

Cheers

--
macropod
[MVP - Microsoft Word]


"PhilD" <phildeaves@xxxxxxxxxxx> wrote in message
news:1163601732.699255.151450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

RD3587 wrote:
I am trying to take a date, like 10-05-2006 and I want to know how many
months and days have gone by since then every time I open the
document... Is there a way of doing this?

When I do that kind of thing, I put the "reference" date in one cell,
"=TODAY()" in another cell, and a simple subtraction between the two
where I want the result. To look pretty, you can format the reference
and TODAY cells so that the text is invisible.

If the date cells are formatted as such, the result cell will will give
the number of elapsed days.

PhilD

--
<><



.

Relevant Pages

  • Re: Suming Cells that contain text data
    ... Biff's idea about changing the format is on the mark. ... Dispense with the letters in those rows also. ... Columns C:I & K:Q will be the only rows where text will ever appear in a cell ... attempt to reference more than one cell. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Odd Problem with HLOOKUP -- Any change breaks it
    ... I simply changed the value in the reference cell ... At open the cell contains "2" to make it lookup another column ... I tried to do to get around the original problem. ... what is already inside the cell will remeber the original format. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Automated file name retrieval and updates
    ... > I have just figured out how to make the cell reference work through the ... >> I am trying to adjust it by dragging it is assuming that I want the text to ... >>> Note that you will have to set the format for the cells properly. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: cell reference changes and conditional formatting
    ... figured out that I had to take the 'fixed' out of the cell letter AND number. ... copy the cell containing that reference right OR down, ... The problem is when I use the format painter, ... this is repeated three more times (going down the spreadsheet for each week). ...
    (microsoft.public.excel.worksheet.functions)
  • Re: cannot get concatenated formula to evaluate...
    ... If you only want to sum D4:endcell where endcell holds a cell reference like ... searching and reading posts and checking some referenced knowledge ... formatted as text and used F2 everytime I changed the format. ...
    (microsoft.public.excel.misc)