If condition - Change the number to Weeks

Hi Team,

i am currently using the formula =IFERROR(IF(AY12-BA12<0,"",AY12-BA12),"") and the result of this formula comes in number. i am trying to update this formula in such a way the number is changed to weeks.

Ex : If the result of the above mentioned formula is 21, i need it as "3 weeks" insted of 21.

Please help.

Originally Posted by boopathiraja

hI, tRY

Formula:

Please Login or Register  to view this content.

The result came in number. how do i add "Week" to the number? if the result of the formula is "2", how do i make it to "2 Weeks"

Does this help?

Please Login or Register  to view this content.