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
3.7
Overall Rating
50%
20%
5%
7%
18%
Reviews
R
RAHUL KATHAD
5
****
J
Joy Dutta
4
sir course is awesome but the assignment not given
H
Harshada Munfan
5
Nice course
P
Pratik Meshram
5
where is assignment PDF
Gourav Parmar
5
Hey Provide me the Practice File
G
Gitesh Saini
5
This aap very helpful for human
R
Rishu Baghel
4
sir, can you provide us some table for practice?
S
shams faishal
4
please provide your excel file so it will be easy to learn fast
P
Pintu Kumar
5
improve video quality, because its excel file and the pixel is not good.
Share a personalized message with your friends.