Hi All, In this master class i will explain all important formulas related to Date and Time functions.
1. Today
2. Now
3. Date
4. Month
5. Year
6. Day
7. Hour
8. Minute
9. Sec
10. Days
11. Networkingdays
12. Networkingdays.int
13. Datevalue
14. TimeValue
15. Weekday
16. Weeknum
17. Week in month
18. Days
19. Datedif
20. Eomonth
21. Text
22. Time
Many more nested functions with the help of Date and time formulas.
You will become expert in Date and Time functions in excel. after attending the free master class.
I will teach real time examples and techniques which i use in my daily work.
i will teach you how to extract the weeknum like Week-1, Week-2, Week-3, Week-4 based on months
i will teach you how to get Qtr-1, Qtr-2, Qtr-3, Qtr-4
i will teach you how to get concat of date and time with different methond.
i will teach you how to get difference of time and addition of time if in case more then 24 hrs.
if interested please join my master class.