Get instant live expert help on I need help with excel month year formula
“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
I need formula of year month & date that gives reult of year.
Solved by B. C. in 21 mins
Calendar setup on Excel sheet for selected month and year
Solved by G. H. in 12 mins
The below formula result in a "FALSE" result when there is no date in Column D. I want it to return the value in Column E.
=IF($D74<>"",IF(MONTH(F$73)&YEAR(F$73)<=MONTH($D74)&YEAR($D74),$E74,IF(MONTH(F$73)&YEAR(F$73)>MONTH($D74)&YEAR($D74),0)))
Solved by B. B. in 24 mins