Results 1 to 13 of 13

Entering Dates by typing the month number only

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-20-2014
    Location
    Greece
    MS-Off Ver
    20 yr. old Excel 2002!
    Posts
    710

    Entering Dates by typing the month number only

    Hi

    In a cell formatted as date (month-year) is it possible to:

    i.e enter "12":

    FORMULA BAR shows: Current Year-December-01 (since day not specified).
    The CELL shows: Dec-Current year (2 digit is fine).

    Thanks
    Last edited by drgkt; 01-05-2017 at 06:26 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Number of Days in each month between two dates
    By marshymell0 in forum Excel General
    Replies: 11
    Last Post: 06-15-2015, 01:28 AM
  2. Number of Month between two dates
    By suhabthan in forum Excel General
    Replies: 7
    Last Post: 03-04-2015, 12:59 PM
  3. [SOLVED] count the number of dates for last month and the number of dates for this month
    By JmundleBofA in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-25-2014, 08:37 PM
  4. [SOLVED] Convert number into Dates (End of Month)
    By acsishere in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-14-2013, 02:17 AM
  5. Counting number of unique dates per month in a list of duplicate dates
    By Rackle83 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-22-2013, 10:15 AM
  6. Replies: 2
    Last Post: 12-01-2012, 03:06 PM
  7. Count number of dates in one month
    By korygrandy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-18-2008, 04:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1