Excel Custom Format in Format Cells

Posted on February 24, 2015May 13, 2015 by Wyman W

This Excel tutorial explains how to use Excel Custom Format in Format Cells to format date, time, number, text, conditional formatting, leading zero, etc. You may also want to read: Excel Extract Time from Date Time Excel Display Time from Date Time What is Excel Custom Format? Excel guesses the most appropriate format for the cells when you type something in a Cell. For example, if you type 31/1/2014, Excel guesses it would be a Date, Format is dd/m/yyyy, but it would not guess it is...

Excel EDATE Function to add month

Posted on February 21, 2015February 27, 2015 by Wyman W

What is Excel EDATE Function? Excel EDATE Function is to add (or subtract) specified months to a date. For example, adding 2 months to Jan 14, 2015 would be Mar 14, 2015. Syntax of EDATE EDATE(start_date, months) start_date A date to add months to months Positive integer to indicate to add month to start_date, negative to indicate subtraction By default, a Cell Format is "General" which does not display a date as date format (such as mm/dd/yyyy), instead date is displayed...

Excel Function add year month day hour minute second to date

Posted on February 15, 2015February 27, 2015 by Wyman W

Excel Function add year month day hour minute second to date In this tutorial, I will show how to use Excel Function to: - add year to date - add month to date - add day to date - add hour to date - add minute to date - add second to date I recommend you to read my previous tutorial to understand the concept of time serial. In the following examples, I will assume A1 contains a date 2015 Jul 1. Add year to date Change the Cell Format to dd/mm/yyyy Assume that we add...

Excel Extract Time from Date Time or Extract Date

Posted on February 4, 2015December 7, 2015 by Wyman W

This Excel tutorial explains how to extract time from Date Time (timestamps) or extract date from Date Time in Excel and how to convert date time to time serial (decimal number). You may also want to read: Excel Access VBA extract percentage from text Access Excel VBA extract number from text or extract alphabet Access Excel extract file name from file path Excel Display Time from Date Time Excel Custom Format Excel Extract Time from Date Time / extract date from Date Time Sometim...

Excel Date Function

Posted on January 27, 2015March 14, 2016 by Wyman W

This Excel tutorial explains how to use Excel Date Function. You may also want to read: Excel first date of month and last date of month Excel Date Function Excel Date function is used to transform year, month, day into Date Serial, a numeric value that represents the Date. Why do you need Excel Date Function? Date is being treated specially in Excel. The format you see in Excel worksheet such as dd/mm/yyyy is only a displayed formatting, the underlying value of a Date is a numeric v...

Excel Use Date in IF Condition

Posted on January 27, 2015February 27, 2015 by Wyman W

Excel Use Date in IF Condition (worksheet solution) If you use a Text as a condition in IF, you can simply use double quote on the text such as "Text", but to use Date in IF condition, you cannot simply use double quote on a date. Lets recap how we apply condition on different data type. To apply condition on Number: =IF(A1>5,"large number","small number") To apply condition on Text: =IF(A1="John","My friend","Stranger") What about Date? Should we just use double quote as we ...

Excel Date Time Conversion

Posted on January 23, 2015February 27, 2015 by Wyman W

Excel Date Time Conversion Excel has a special way to treat Date Time value but most people are not aware of that. You need to understand the meaning of the numeric values that represent Excel Date Time in order that you can freely perform Excel date time conversion to hours, minutes, days, etc. After you understand the meaning of the numerical values, you can easily calculate Excel Date Time Difference. Also read the below post about calculate time difference Excel time difference in ho...

Excel Networkdays function to exclude weekend

Posted on December 26, 2014March 1, 2015 by Wyman W

This tutorial explains how to use Excel Networkdays Function to exclude weekend and holiday. Excel Networkdays function to exclude weekend and holiday Excel Networkdays Function literally means "net working days", which calculates the number of days between two specific days, excluding weekend (Saturday and Sunday) and holiday. Both start date and end date inclusive. For example, from Jan 1st, 2015 (Thu) to Jan 5th, 2015 (Monday), total number of Networkdays is three. The function counts...

Excel DATEDIF Function to calculate date difference

Posted on December 8, 2014July 7, 2017 by Wyman W

This tutorial explains how to use Excel DATEDIF Function to calculate date difference (difference between two dates) in complete year, month or day. You may also want to read: Access Excel VBA day month year difference between two dates Excel DATEDIF Function DATEDIF function stands for "Date Difference". It calculates the difference between two dates in complete year, month or day. Note that DATEDIF Function returns the "complete" value, for example, if the year difference between two d...

Custom VBA Excel Access Networkdays Function

Posted on December 4, 2014March 7, 2015 by Wyman W

This tutorial explains how to create a custom Excel Access Networkdays Function to simulate Excel Networkdays Function, exclude holiday and weekend Why do we need Access Networkdays Function? As of Access 2013 version, there is no Access Networkdays Function available, the function is only available in Excel all versions. In Excel , Networkdays Function is used to calculate the number of "net working days" between two days, excluding Saturday and Sunday, and include both start date and end ...