Results 1 to 4 of 4

Date format changes to numbers in simple formula

Threaded View

Little Tree Date format changes to... 11-09-2022, 11:35 AM
AliGW Re: Date format changes to... 11-09-2022, 11:42 AM
Little Tree Re: Date format changes to... 11-09-2022, 11:58 AM
AliGW Re: Date format changes to... 11-09-2022, 12:08 PM
  1. #1
    Registered User
    Join Date
    06-08-2022
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4

    Date format changes to numbers in simple formula

    After scouring this forum I wasn't able to find the answer I was looking for.
    To simplify my formula lets say cell A1 is a date:
    12/31/2023
    Cell B1 is that date plus one day:
    =A1+1
    returns me: 01-Jan
    Cell C1 is that date plus five days:
    =A1+5
    returns me: 05-Jan
    In cell D1 I have:
    ="From "&B1&" to "&C1
    I want D1 to read a from and to date like this:
    From 01-Jan to 05-Jan
    But I get this...
    From 45292 to 45296
    Formatting the cell to date format yields no result... Any advice? Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Simple date & month format request
    By munishjain in forum Excel General
    Replies: 2
    Last Post: 08-12-2020, 06:52 AM
  2. [SOLVED] simple macro to format numbers doesnt work
    By fruitloop44 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2018, 12:52 AM
  3. [SOLVED] simple (hopefully) date/text format issue
    By gee83 in forum Excel General
    Replies: 3
    Last Post: 01-11-2018, 11:19 AM
  4. [SOLVED] URGENT - how do you do simple sums with cells set to date format
    By Muzza86 in forum Excel General
    Replies: 8
    Last Post: 06-25-2014, 07:03 AM
  5. Replies: 7
    Last Post: 02-17-2014, 04:48 AM
  6. Need Formula/VBA Code to convert date in String Format to Normal Date format
    By Karthik Sen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2012, 04:54 AM
  7. Simple Question, display only part of a date in Number format
    By DB Explorer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-17-2006, 07:50 AM

Tags for this Thread

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