The DAYS360 function calculates the number of days between two dates using a 360-day year (12 30-day months), which is commonly used in accounting computations. If your accounting system is based on twelve 30-day months, you can use this function to assist you calculate payments.
The DATEVALUE function transforms a text date into a serial number that Excel can recognise as a date. The formula =DATEVALUE("1/1/2008"), for example, produces 39448, the date's serial number.
The DATEVALUE function in Excel turns a text string date into a valid Excel date. For example, in the Excel date system, the formula =DATEVALUE("3/10/1975") returns a serial number (27463) that reflects March 10, 1975.
Learner's Ratings
4
Overall Rating
56%
21%
6%
6%
11%
Reviews
N
Nitesh kumar gupta
5
nice course all the video explained very well from scratch to advance
S
Shubham Maurice
5
Overall Lectures are good but also provide the practicing spreadsheets for students.
S
Shivam Gautam
5
very good experience
K
KALAGA NARAYAN
5
i dont think some one can explain deeply ,practically rathere than this tutor
L
Lavkesh Kushwaha
5
West
K
Kamran Ahmed
5
Helpful course
S
sanjeet kumar
4
some excercise should be there. I have not studied standerd deviation of population in second module but question has been asked.
V
Vishisht
5
good
S
Shringa A G
5
This is a really helpful course for beginners as well as experts. You can develop your skills from this course.
Share a personalized message with your friends.