LinkBack URL
About LinkBacks
The date in excel 2016 shown as 1905 where as the format for date in windows is between 1950 & 2049.
Please guide
The date in excel 2016 shown as 1905 where as the format for date in windows is between 1950 & 2049.
Please guide
is the date field the results of a calculation?
if so we'd need to see the calculation and your workbook settings - for example are your workbook settings (under options) using the 1904 date system?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
@masafi.ermo.... My guess is: you are entering just the year number (2016, 2018 and 2019) -- as the column title suggests -- then formatting the cells as Date.
Instead, you should format the cell as General or Number with zero decimal places.
FYI, Excel dates are stored as integers, namely the number of days after 31/12/1899 (normally).
So if you format the integers 2016, 2018 and 2019 as Date, they will appear to be dates that are that number of days after 31/12/1899, which are 7/7/1905, 10/7/1905 and 11/7/1905 that you see.
No, the date is not as a result of any calculation, but entered as normal date. Excel sheet is attached herewith for reference.
Excel sheet is attached herewith for reference.
Please change the format of Column G in General.
See my posting #3. A year number is not a "normal date". See column H in the attached file.Originally Posted by masafi.ermo
If you want the year number to look like a "normal date" (d/m/yyyy), what day and month do you expect to see?
If you want day 1 of month 1, you must enter the "normal date" 1/1/2015, not just 2015, for example.
But your title of column G is "Year". So I would expect to see just a year number (2015) in column G, which is exactly what you entered.
In that case, just format column G as I suggested in posting #3.
-----
Last edited by curiouscat408; 09-08-2022 at 01:36 AM.
Thanks for your help
Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks