Total days worked /20 to get actual months/days

[Cindy]

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?

 

[Bob Phillips]

=INT(A2/20)&" months "&MOD(A2,20)&" days"

 

[T. Valko]

Try this...

A1 = 76

For the months:

=INT(A1/20)

For the days:

=MOD(A1,20)

If you want it combined into a single expression (all on one line):

=INT(A1/20)&" Month"&IF(INT(A1/20)<>1,"s","")
&" "&MOD(A1,20)&" Day"&IF(MOD(A1,20)<>1,"s","")

 

[Gord Dibben]

Days worked in A1

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

Entered in B1


Gord Dibben MS Excel MVP