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.
