+ Reply to Thread
Results 1 to 3 of 3

Add now function with out time and with specific format

  1. 01-08-2017, 05:07 AM #1
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Add now function with out time and with specific format

    hi, everyone
    i am using below code to get now date and time
    Please Login or Register  to view this content.
    and its giving me the output result 
    Please Login or Register  to view this content.
    while
    i want only date with format below
    Please Login or Register  to view this content.

    thanx
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *
    Reply With QuoteRegister To Reply
  2. 01-08-2017, 07:50 AM #2
    kasan
    kasan is offline
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Add now function with out time and with specific format

    You should format your output, like this
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 01-08-2017, 09:27 AM #3
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Add now function with out time and with specific format

    Thanx kasan
    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)

Similar Threads

  1. Function - entering time in mm:ss:ss format
    By SJB777 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2015, 09:05 AM
  2. [SOLVED] I want telephone numbers and time of any format to specific format
    By Latha Mani in forum Excel General
    Replies: 16
    Last Post: 01-11-2014, 09:58 AM
  3. Custom time format, how to create specific format?
    By JackBauer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-26-2013, 03:05 AM
  4. [SOLVED] if function not returning value when in time format
    By HPIMICHAEL02 in forum Excel General
    Replies: 4
    Last Post: 12-09-2012, 08:31 AM
  5. Need to add a specific time to the TODAY() function?
    By Wabby in forum Excel General
    Replies: 3
    Last Post: 01-12-2010, 05:17 AM
  6. Creating a time-format formula/function
    By Nayuki in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-14-2008, 06:48 PM
  7. Time format hh:mm:ss without the AM/PM function
    By mst7233 in forum Excel General
    Replies: 1
    Last Post: 10-31-2007, 06:31 PM

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