Jul 24 2019 01:43 PM
I've been trying to relay a month-month formula in Excel 2013. Where if a Date value is inputted in a cell, another cell (with formula) would display "1st date of month-last date of month" i.e. - if A1 reads "4-1-19" A2 would read "4/1/19-4/30/19".
if A1 reads "5-1-19" A2 would read "5/1/19-5/31/19" so forth and so on...
Is this even a function in Excel?
Jul 24 2019 02:07 PM
Jul 24 2019 03:34 PM
SolutionHi
You can use one of 2 functions (EOMONTH or DATE) in combination with a TEXT function to set the formatting you want. Since the EOMONTH has been already provided, then here is the other one
You can use the formula
=TEXT(DATE(YEAR(A1),MONTH(A1),1),"mm/dd/yy")&
" - "&TEXT(DATE(YEAR(A1),MONTH(A1)+1,0),"mm/dd/YY")
Hope that helps
Nabil Mourad
Jul 25 2019 12:15 PM
worked! thanks a million @nabilmourad
Jul 25 2019 12:19 PM
Jul 25 2019 12:19 PM
worked also, thank you! @Sergei Baklan
Jul 24 2019 03:34 PM
SolutionHi
You can use one of 2 functions (EOMONTH or DATE) in combination with a TEXT function to set the formatting you want. Since the EOMONTH has been already provided, then here is the other one
You can use the formula
=TEXT(DATE(YEAR(A1),MONTH(A1),1),"mm/dd/yy")&
" - "&TEXT(DATE(YEAR(A1),MONTH(A1)+1,0),"mm/dd/YY")
Hope that helps
Nabil Mourad