Thread: Total days worked /20 to get actual months/days
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Total days worked /20 to get actual months/days
Days worked in A1

=INT(A1/20)&" months "&20*((A1/20)-INT(A1/20))&" days"

Entered in B1


Gord Dibben MS Excel MVP


On Thu, 22 Oct 2009 14:20:01 -0700, Cindy
wrote:

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