+ Reply to Thread
Results 1 to 26 of 26

Remove Time Element of a Date

  1. 07-08-2005, 04:42 AM #1
    jennie
    jennie is offline
    Registered User
    Join Date
    03-02-2004
    Posts
    15

    Question Remove Time Element of a Date

    Hi,

    I have a list of cells with a date and time value - I want a formula that will remove the time element and just leave a date.

    Thanks
    Jennie
    Reply With QuoteRegister To Reply
  2. 07-08-2005, 06:05 AM #2
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  3. 07-08-2005, 06:36 AM #3
    jennie
    jennie is offline
    Registered User
    Join Date
    03-02-2004
    Posts
    15

    Smile

    Thanks a lot
    Jennie
    Reply With QuoteRegister To Reply
  4. 07-08-2005, 07:05 AM #4
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
  5. 09-05-2005, 10:05 PM #5
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  6. 09-05-2005, 10:05 PM #6
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
  7. 09-05-2005, 11:05 PM #7
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  8. 09-05-2005, 11:05 PM #8
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
  9. 09-06-2005, 12:05 AM #9
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  10. 09-06-2005, 12:05 AM #10
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
  11. 09-06-2005, 01:05 AM #11
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  12. 09-06-2005, 01:05 AM #12
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
  13. 09-06-2005, 02:05 AM #13
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
  14. 09-06-2005, 02:05 AM #14
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  15. 09-06-2005, 03:05 AM #15
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
  16. 09-06-2005, 03:05 AM #16
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  17. 09-06-2005, 04:05 AM #17
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
  18. 09-06-2005, 04:05 AM #18
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  19. 09-06-2005, 06:05 AM #19
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
  20. 09-06-2005, 06:05 AM #20
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  21. 09-06-2005, 07:05 AM #21
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
  22. 09-06-2005, 07:05 AM #22
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  23. 09-06-2005, 10:05 AM #23
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  24. 09-06-2005, 10:05 AM #24
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
  25. 09-06-2005, 12:05 PM #25
    VoG
    Guest

    Re: Remove Time Element of a Date

    With a date in A2

    =DATE(YEAR(A2),MONTH(A2),DAY(A2))


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  26. 09-06-2005, 12:05 PM #26
    Ron Rosenfeld
    Guest

    Re: Remove Time Element of a Date

    On Fri, 8 Jul 2005 03:42:22 -0500, jennie
    <[email protected]> wrote:

    >
    >Hi,
    >
    >I have a list of cells with a date and time value - I want a formula
    >that will remove the time element and just leave a date.
    >
    >Thanks
    >Jennie


    =INT(cell_ref)


    --ron
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1