Get instant live expert help on month year excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I am having an issue with an excel formula not returning the expected results. =IF($F2<>"",IF(YEAR(Y$1)&MONTH(Y$1)<=YEAR($F2)&MONTH($F2),$T2,IF(YEAR(Y$1)&MONTH(Y$1)>YEAR($F2)&MONTH($F2),0)),$T2)
Solved by C. D. in 21 mins
=IF($P5="Annual",IF(AND(YEAR($R5)=YEAR(S$4),MONTH($R5)=MONTH(S$4)),"Y",""),IF($P5="Semi-Annual",IF(AND(YEAR($R5)=YEAR(S$4),OR(MONTH($R5)=MONTH(S$4),MONTH($R5)=MONTH(S$4)+6)),"Y",""),IF($P5="Quarter",IF(AND(YEAR($R5)=YEAR(S$4),OR(MONTH($R5)=MONTH(S$4),MONTH($R5)=MONTH(S$4)+3,MONTH($R5)=MONTH(S$4)+6,MONTH($R5)=MONTH(S$4)+9)),"Y",""),""))) fix this formula please
Solved by O. J. in 27 mins
Calendar setup on Excel sheet for selected month and year
Solved by G. H. in 12 mins
I have one number 181101 - It signifies 18 as YEAR, 11 is the Month (November) and 01 is the batch Number...Excel is extracting Year and Month, as digits, though my requirement is to extract Year as 2018 and Month as Nov. Please help
Solved by I. Y. in 28 mins
I need every month second tuesday dates for whole year in excel
Solved by C. B. in 23 mins