How to Get Start Date end Date of a Month Form a Date
Written by kazamraza no comments
Classified in : Excel Formulas, Date & Time Functions
Sometimes we need start date and end date of a month for our financial model. We can solve this problem by using EOMONTH Function.
If we use months value equal to 0 then this function return last day of the month as of start date as shown below.
|1||Current Date||26/Jun/2020||Result||Apply Date Formatting on Column C|