Excel formula

This query is : Resolved

Querist : Anonymous

Querist : Anonymous (Querist)

21 May 2016 sir,
i want to know the excel fomula for converting the days into months.
pls elaborate with example.
pls as soon as possible.

CA Puneet B. Gandhi

CA Puneet B. Gandhi (Expert)
Follow

21 May 2016 Hi,

You can convert days into months by simply dividing the number of days by 30 or 31.
I suppose you are trying to do some Date and Time calculations. In that case please explain with example what you exactly require so I can help you further.

Querist : Anonymous

Querist : Anonymous (Querist)

23 May 2016 actually sir i want to convert the over due date of debtors which is given in days in tally.
eg. 141 days of tally want to convert in excel sheet in months like 4 month 2 days

Upgrade to CAclubindia Pro. Subscribe Now!

CA Puneet B. Gandhi

CA Puneet B. Gandhi (Expert)
Follow

23 May 2016 Hi,

You can use below formula to convert the days in months.
=CONCATENATE((ROUNDDOWN(A3/30,0))," months ",(A3-((ROUNDDOWN(A3/30,0))*30))," days")

In the formula you can update cell A3 with the cell in which you have number of days. This will convert number of days into - 'X months Y days' as required by you. Please note that the formula works on the assumption of 30 days in a month, so it will provide approximate result.

If you have the actual date from which debtors' account is overdue, we can use other formulas to derive accurate results.

Querist : Anonymous

Querist : Anonymous (Querist)

25 May 2016 thank you very much sir
its really help me a lot