Thread: Total days worked /20 to get actual months/days
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default Total days worked /20 to get actual months/days
=INT(A2/20)&" months "&MOD(A2,20)&" days"

--
__________________________________
HTH

Bob

"Cindy" wrote in message
...
We have to report actual days worked by months/day. A work month = 20
days.
How do I take total days worked of say 76 and get the answer to show 3
months
16 days?


Reply With QuoteReply With Quote