previous NEXT YEAR FRAC Syntax=YEARFRAC(StartDate,EndData,Basis)Basis : Defines the calendar system to be used in the function.0 : or omitted USA style 30 days per month divided by 360.1 : 29...
Read More YEAR
0 Comments , in Uncategorized
previous NEXT Year What Does It Do?This function extracts the year number from a date. Syntax=YEAR(Date) FormattingThe result is shown as a number. Date Year ####### 1998 =YEAR(C4) previous NEXT...
Read More
previous NEXT eomonth What Does It Do?This function will show the last day of the month which is a specified number of months before or after a given date. Syntax=EOMONTH(StartDate,Months)...
Read More
previous NEXT work day What Does It Do?Use this function to calculate a past or future date based on a starting date and aspecified number of days. The function excludes...
Read More
previous NEXT week day The result will be shown as a normal number. To show the result as the name of the day, use Format, Cells, Custom and set the...
Read More TODAY
0 Comments , in Uncategorized
previous NEXT Today What Does It Do?Use this to show the current date. Syntax=TODAY() FormattingThe result will normally be displayed using the DD-MM-YY format. Today Is 23-Jan-20 =TODAY() Example: The...
Read More
previous NEXT days 360 What Does It Do?Shows the number of days between two dates based on a 360-day year (twelve 30-day months).Use this function if your accounting system is...
Read More DAY
0 Comments , in Uncategorized
previous NEXT day What Does It Do?This function extracts the day of the month from a complete date. Syntax=DAY(value) FormattingNormally the result will be a number, but this can be...
Read More TIME
0 Comments , in Uncategorized
previous NEXT time What Does It Do?This function will convert three separate numbers to an actual time. Syntax=TIME(Hour,Minute,Second) FormattingThe result will be shown as a time which can be formatted...
Read More
previous NEXT Time Calculation Excel can work with time very easily. Time can be entered in various different formats and calculations performed. There are one or two oddities, but nothing...
Read More