Class 7: Date Function Part 3 Copy

Click Here to Drop Your Doubts

Summary: In this class, Jaywant Sir will be explaining D-Function.

Process: EOMONTH: To find the end of the month from your data the formula is =eomonth( Start date, Months)

To change the format for it just to show the month go to Home Tab Ribbon, Go to Number Section, Click on General/Custom, then click on More Number Formats, in the number category click on custom, type your format mmmm , click okay.

To find the 2 months prior end of the month from your data the formula is =emonth(Start date,-Months)

To change the format for it to show the whole date go to Home Tab Ribbon, Go to Number Section, Click on General/Custom, then click on the date.

EDATE: To find the end date from your data the formula is =edate(Start number, Months)

To change the format for it to show the whole date go to Home Tab Ribbon, Go to Number Section, Click on General/Custom, then click on More Number Formats, in the number category click on custom, type your format dd-mm-yy , click okay.

WEEKDAY: To find the weekday from your data the formula is =weekday( Select the target data, Return type)

WEEKNUM: To find the week number from your data the formula is =weeknum( Select target data, Return type)Conclusion: After completion of this class you will be able to do d-function which are as follows Eomonth,  Edate, Weekday, Weeknum.

Conclusion: After completion of this class you will be able to do d-function which are as follows Eomonth,  Edate, Weekday, Weeknum.