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","")

--
Biff
Microsoft Excel MVP


"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?