Home > Excel Help Portal > Dates and Times in Excel

<<  (Page 1)  Previous              Next  (Page 3)  >>

Dates and Times in Excel

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses calculating dates and
times in Excel.

51. MSQuery Uses 1900 Date When Two Digits Are Used for Year
52. How to modify a Particular Time with the TIME and MOD Functions in Excel 2000
53. How to use the Auto Fill Options button in Excel
54. Days of the Week Before March 1, 1900 Are Incorrect
55. Dates Inserted by Recorded Macro May Be in Wrong Century
56. A Visual Basic Nested Case Statement Example
57. How to Display the Current Date and Time with Text
58. Excel Pivot Table Date Order
59. Advanced Pivot Table Operations
60. Help using Excel spreadsheet functions - text, abs
61. IF THEN in worksheet functions and in VBA
62. Examples of Interest Calculations Outside the United States
63. How to work with Serial Number Dates and Julian Dates in Microsoft Excel 2000
64. SORTING, some notes on sorting in Excel
65. The Excel DATEDIF function
66. Formatting Time Values
67. Automatically get the date and time
68. How to convert Dates in Imported Files from yy/mm/dd to mm/dd/yy Format in Excel 2000
69. How to Return a Day of the Week for a Date That Is Contained in a Cell in Excel
70. Excel 2000: Excel Quits When GetPivotData Function Is in Second Workbook
71. Maximum Times in Microsoft Excel
72. Calculation Problems When Custom Function Creates a Defined Name
73. How to turn AutoComplete On or Off in Excel 2000
74. Return End Of Month Date
75. How to calculate the Number of Months Between Two Dates in Excel 2000
76. You Cannot Reopen a File After You Save It
77. Excel site index
78. Formula to add years to a given date
79. Mapinfo Professional to create Excel Maps
80. How to Calculate the Number of Months Between Two Given Dates
81. Convert daily dates to monthly dates
82. Rearrange a Text File
83. Write a Formula that always points to the same column, but is free to move to different rows as it is copied
84. Formulas That Return the Last or First Day of a Month
85. Excel -- Pivot Tables -- Grouping Data
86. Excel -- Data Validation -- Custom Validation Criteria Examples
87. Setup Print in Macro
88. Date and Time Tutorial
89. Determine Years, Months, & Days between 2 Dates
90. Print a Multiple Sheet Workbook with Page Numbers
91. Stamp Auction application -- Dialogs, input boxes, UserForms
92. Parsing Dates
93. Excel Code Examples
94. Working with Dates
95. Formatting Time Values
96. Use Date in Naming Convention
97. Macros - Custom Excel Macros in VBA from Mr Excel
98. Number of Days, Months and Years Between Two Dates
99. Using Built-In Workday Calculation Functions
100. Calculate the day of the year and days remaining

<< (Page 1)  Previous              Next  (Page 3) >>