1. =today()
    Today function is use to display current system date.



2. =now()
    Now function is use to display both current date and time.



3. =month()
    Month function is use to display only part from given date. Dates are in US Format (MM:DD:YYYY). This type of format depends on your windows regional settings




4. =year()
    Year function is use to display only year part from given date.




5. =day()
    Day function is use to return only day part from a given date.




6. =hour()
    Hour function is use to return only hour part from given time.




7. =minute()
    Minute function is use to return only minute part from given time.





8. =second()
    Second function is use to return second part from given time.





9. =days360()
    This function returns number of days between two given date. But it take 360 days per year.

    Note:  Dates are in US Format (MM:DD:YYYY). This type of format depends on your windows      regional settings



10. =datedif()
    This function returns the gap between two given date. That gap may be month, year or date.



11. =weekday()
    This function return the numeric value of given week.


Note:For Sunday-1, Monday-2, Tuesday-3, Wednesday-4, Thursday-5, Friday-6, Saturday-7