Forum Discussion
SPC123
Apr 03, 2020Copper Contributor
Convert Days to whole months
I have a list of days that I would like to convert to months. Started with a formula: =IF(AND(BO2>=1,BO2<=30),"1 Month",IF(AND(BO2>=31,BO2<=60),"2 Months" etc. However, my list of days is ...
Detlef_Lewin
Apr 03, 2020Silver Contributor
- SPC123Apr 06, 2020Copper Contributor
Thank you! Detlef_Lewin