YEAR FRAC

0 Comments , in

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

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

EOMONTH

0 Comments , in

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

WORK DAY

0 Comments , in

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

TODAY

0 Comments , in

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

DAYS 360

0 Comments , in

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

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

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

TIME CALCULATION

0 Comments , in

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