Get instant live expert help on month to year

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

=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 to do a month to month, quarter to quarter and FY year to year
Solved by O. Q. in 25 mins
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
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
I need formula of year month & date that gives reult of year.
Solved by B. C. in 21 mins