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.
Syntax
EOMONTH(start_date, months)
If we use months value equal to 0 then this function return last day of the month as of start date as shown below.
| ◢ | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Current Date | 26/Jun/2020 | Result | Apply Date Formatting on Column C | |
| 2 | Start Date | =EOMONTH(B1,-1)+1 | 43983 | 01/Jun/2020 | |
| 3 | End Date | =EOMONTH(B1,0) | 44012 | 30/Jun/2020 | |
| 4 |