LinkBack URL
About LinkBacks
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"Originally Posted by boopathiraja
hI, tRY
Formula:
=IFERROR(IF(AY12-BA12<0,"",INT((AY12-BA12)/7)),"")
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"hI, tRY
Formula:=IFERROR(IF(AY12-BA12<0,"",INT((AY12-BA12)/7)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks