#### nicolecas

##### New Member
Hi all, another formula question... I have length of service for months in the form of a decimal say 3.32. I need a formula that will allow me to see how many days that actually is. Any help is greatly appreciated.

Nicole

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### alvin-chung

##### Active Member
Hi Nicole, as various months having different number days are you assuming 1.0 month = 30 days?
If yes, the formula would be simply =3.32*30 (days)?

Thank you

You're welcome

Replies
5
Views
116
Replies
8
Views
106
Replies
2
Views
104
Replies
1
Views
243
Replies
1
Views
49

1,171,469
Messages
5,875,675
Members
433,148
Latest member
lammatt145

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back