Search Contextures Sites
1. Excel Time Calculations
2. Excel Date Calculations
How can I enter the date into a cell so it doesn't change every day?
To enter the current date, press Ctrl + ; (hold the Ctrl key while typing a semicolon.)
To enter the current time, press Ctrl + : (hold the Ctrl key while typing a colon.)When I copy and paste Excel dates, they end up one day wrong.
When I copy and paste dates, they end up four years wrong.One workbook is using 1904 calendar, the other one 1900 (in the first example, years are not displayed, but definitely present). Go menu Tools>Options, Calculation and make them equal, preferably also correct if you know what the dates was supposed to be.
How do I add 3 months to an Excel date?
=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))
Could someone give me the series of worksheet functions that would emulate EOMONTH; last day of month?
The last day of the month equals the zero'th of next month for some strange reason: =DATE(YEAR(A1),MONTH(A1)+1,0)
Excel thinks 1900 is a leap year. It's not.
Yes it does and it's not. The following MSKB article explains the reason:
Excel 2000 incorrectly assumes that the year 1900 is a leap year
http://support.microsoft.com/kb/2143263. Excel Date and Time Resources
Where can I find more information on Excel dates and times?
Chip Pearson's web page on dates and times will give you an understanding of how this works in Excel , and it has lots of useful date and time samples.
Original FAQs compiled by Harald Staff, Excel MVP 20002005. Additions by Debra Dalgleish.





Last updated: September 12, 2013 12:09 AM