#### Convert Number of Month to Number of days

```Hi,

I am doing a small analysis, where I need to convert Number of Month into
number of days.

For E.g. 25 month = __ # days.

To better understand.
Date = 01/28/2010
Opening stock = 100
Stock good for = 6 months
Date of next order = ?? (Stock good for months - put opening date + 10 days)

There I need to convert the months into days so that I can substract the
opening date from it.

Kindly help.
Dinesh

```
 0
Utf
1/28/2010 3:08:04 PM
excel.misc 78881 articles. 0 followers.

4 Replies
4198 Views

Similar Articles

[PageSpeed] 5

```Hi,

I don't understand the question, I got lost when 10 days appeared. But date
arithmetic in Excel is very simple and it's unlikely you will need to convert
the date to days or anything else to do that arithmetic.

For example to add 6 months to a date in a1

=DATE(YEAR(A1), MONTH(A1)+6, DAY(A1))

http://www.cpearson.com/excel/datearith.htm
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"nsd" wrote:

> Hi,
>
> I am doing a small analysis, where I need to convert Number of Month into
> number of days.
>
> For E.g. 25 month = __ # days.
>
> To better understand.
> Date = 01/28/2010
> Opening stock = 100
> Stock good for = 6 months
> Date of next order = ?? (Stock good for months - put opening date + 10 days)
>
> There I need to convert the months into days so that I can substract the
> opening date from it.
>
>
> Kindly help.
> Dinesh
>
>
>
```
 0
Utf
1/28/2010 3:16:02 PM
```Hey Mike,

Thanks for you answer and apologies on my ability to put my question
correctly.

I am trying to make a sheet where I know when to order what.  for e.g. I
have Stock update of this morning and I know that stock will be consumed in 6
months and I have to reorder atleast 10 days earlier than the stock ending
date (which is after 6 months).  This is why I wanted to know when (which
date) should I replace the order for that particular stock.

I am still affraid if you understand my question. Any ways, from your last

Thanks a ton.
Dinesh

"Mike H" wrote:

> Hi,
>
> I don't understand the question, I got lost when 10 days appeared. But date
> arithmetic in Excel is very simple and it's unlikely you will need to convert
> the date to days or anything else to do that arithmetic.
>
> For example to add 6 months to a date in a1
>
> =DATE(YEAR(A1), MONTH(A1)+6, DAY(A1))
>
>
> http://www.cpearson.com/excel/datearith.htm
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "nsd" wrote:
>
> > Hi,
> >
> > I am doing a small analysis, where I need to convert Number of Month into
> > number of days.
> >
> > For E.g. 25 month = __ # days.
> >
> > To better understand.
> > Date = 01/28/2010
> > Opening stock = 100
> > Stock good for = 6 months
> > Date of next order = ?? (Stock good for months - put opening date + 10 days)
> >
> > There I need to convert the months into days so that I can substract the
> > opening date from it.
> >
> >
> > Kindly help.
> > Dinesh
> >
> >
> >
```
 0
Utf
1/28/2010 3:30:11 PM
```Hi,

Then it's simply a variation on the formula I gave you. With a date in a1,
this adds 6 months minus 10 days

=DATE(YEAR(A1), MONTH(A1)+6, DAY(A1))-10
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"nsd" wrote:

> Hey Mike,
>
> Thanks for you answer and apologies on my ability to put my question
> correctly.
>
> I am trying to make a sheet where I know when to order what.  for e.g. I
> have Stock update of this morning and I know that stock will be consumed in 6
> months and I have to reorder atleast 10 days earlier than the stock ending
> date (which is after 6 months).  This is why I wanted to know when (which
> date) should I replace the order for that particular stock.
>
> I am still affraid if you understand my question. Any ways, from your last
>
> Thanks a ton.
> Dinesh
>
> "Mike H" wrote:
>
> > Hi,
> >
> > I don't understand the question, I got lost when 10 days appeared. But date
> > arithmetic in Excel is very simple and it's unlikely you will need to convert
> > the date to days or anything else to do that arithmetic.
> >
> > For example to add 6 months to a date in a1
> >
> > =DATE(YEAR(A1), MONTH(A1)+6, DAY(A1))
> >
> >
> > http://www.cpearson.com/excel/datearith.htm
> > --
> > Mike
> >
> > When competing hypotheses are otherwise equal, adopt the hypothesis that
> > introduces the fewest assumptions while still sufficiently answering the
> > question.
> >
> >
> > "nsd" wrote:
> >
> > > Hi,
> > >
> > > I am doing a small analysis, where I need to convert Number of Month into
> > > number of days.
> > >
> > > For E.g. 25 month = __ # days.
> > >
> > > To better understand.
> > > Date = 01/28/2010
> > > Opening stock = 100
> > > Stock good for = 6 months
> > > Date of next order = ?? (Stock good for months - put opening date + 10 days)
> > >
> > > There I need to convert the months into days so that I can substract the
> > > opening date from it.
> > >
> > >
> > > Kindly help.
> > > Dinesh
> > >
> > >
> > >
```
 0
Utf
1/28/2010 3:43:02 PM
```I have one more question if you can help please.

I have a matrix as under:

Days                      <30 day           <60 days            <90
days
Units
0-100                              \$20                  \$30
\$40
100-200                          \$15                  \$25
\$35
201-300                          \$12                  \$22
\$32

This shows if my order is between 0-100 units and if I pay in less than 30
days then my price of the product would be \$20. Further, if my order is
between 0-100 and if I pay in less that 90 days then my value of the product
would be \$40.

Can I have a formula where in a column I put my value and no. of days
payment and the formula will get me the price/value or the product from this
matrix. For e.g. A1  column I put the no. of unit I want (let's say 25 units)
and in B1 column I put the no. of days I would pay in (let's say 45 days),
and in C1 I get the price as (\$30 x 25 units). That means C1 would have a
formula.

Hope this time I made my question clear. I tried to do it by lookup function
but without success.

Dinesh
"Mike H" wrote:

> Hi,
>
> I don't understand the question, I got lost when 10 days appeared. But date
> arithmetic in Excel is very simple and it's unlikely you will need to convert
> the date to days or anything else to do that arithmetic.
>
> For example to add 6 months to a date in a1
>
> =DATE(YEAR(A1), MONTH(A1)+6, DAY(A1))
>
>
> http://www.cpearson.com/excel/datearith.htm
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "nsd" wrote:
>
> > Hi,
> >
> > I am doing a small analysis, where I need to convert Number of Month into
> > number of days.
> >
> > For E.g. 25 month = __ # days.
> >
> > To better understand.
> > Date = 01/28/2010
> > Opening stock = 100
> > Stock good for = 6 months
> > Date of next order = ?? (Stock good for months - put opening date + 10 days)
> >
> > There I need to convert the months into days so that I can substract the
> > opening date from it.
> >
> >
> > Kindly help.
> > Dinesh
> >
> >
> >
```
 0
Utf
1/28/2010 3:45:01 PM

Similar Artilces:

Help Me Convert Fraction
I'm trying to customize a worksheet to read the fractions such as 14/16 as 7/8, 4/16 as 1/4, 8/16 as 1/2 etc. Can this be done and if so, does anyone out there explain to me how to do this? I'm using Excel2000. Thanks!! CB Take a look here: http://www.mvps.org/dmcritchie/excel/fractex1.htm In article <vpjn0s47vn3081@corp.supernews.com>, "Charlie Brandon" <cbrandon@plateautel.net> wrote: > I'm trying to customize a worksheet to read the fractions such as 14/16 as > 7/8, 4/16 as 1/4, 8/16 as 1/2 etc. Can this be done and if so, does anyone > ...

How do i create an automatic monthly cash flow from lists of cost.
I am in the process of creating a 'Project Costings' solution which I hope colleagues at work can easily input basic project data into. Excel will then calcualte all the necessary figures e.g. Overheads etc. without using VBA My question is how do I get my monthly Cash Flow statement to automatically update in categories from a seperate sheet of costs i.e. If I have a list of 10 items in say Equipment budget listed down with dates of purchase next to them. How do I then automatically update the Cash Flow statement in the relevant month of purchase with the correct amounts. I...

saving a converted lotus file
When I take a Lotus 123 file and save it as an Excel file and then open the file in Excel, Excel opens the file twice. In the title bar is says name.1 and name.2. Why is this? Hi Pam There are two windows open of the file. http://www.contextures.com/xlfaqApp.html#TwoWindows -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Pam" <anonymous@discussions.microsoft.com> wrote in message news:011501c3c4cb\$1b472b40\$a401280a@phx.gbl... > When I take a Lotus 123 file and save it as an Excel file > and then open the file in Excel, Excel opens the...

convert concencated field to date
Hi Any Ideas? Concencate a number of imported fields into a date - Is is not possible to import the fields as a number. Basically these are the date field from on on line application http://www.ukopforms.co.uk/ukop_application.asp I have tried a number of things DOB: (TableName!Day & TbaleName!Month & TableName!Year) DOB: Val((TableName!Day) & Val(TbaleName!Month) & Val(TableName!Year)) DOB: #Val((TableName!Day) & Val(TbaleName!Month) & Val(TableName!Year))# DOB: ((TableName!Day) &"/"& Val(TbaleName!Month) &"/"& Val(TableName!Y...

convert
Is it possible to convert an excel file into a word file? new wrote: > Is it possible to convert an excel file into a word file? You can imbed an excel file into a word document, otherwise no not as such. You could save the Excel file as text and then open in Word. Why would you want to? Excel is not a word processor and Word is not a spreadsheet application. -- Registered Linux User no 240308 Just waiting for Broadband to complete the conversion!(3 weeks and counting!) gordonATgbpcomputingDOTcoDOTuk to email me remove the obvious! ...

convert HICON to HBITMAP
Hi all, I am trying to convert an icon (already loaded by LoadImage), I have its HICON to a bitmap (HBITMAP), but I don't how. I CAN'T use GDI+( tried do with Bitmap class with the constructor and there was no problem), but I must use GDI. Thanks to all. Abel HBITMAP hbmpBitmap,hbm; HDC hdcScreen, hdcBitmap; int x, y; x = GetSystemMetrics(SM_CXICON); y = GetSystemMetrics(SM_CYICON); hdcScreen = ::GetDC( m_hWnd ); hdcBitmap = ::CreateCompatibleDC(hdcScreen); hbmpBitmap = CreateCompatibleBitmap(hdcScreen, x, y); Re...

Wrong numbers on axes
I have encountered some strange numbering problems on graphs in a number of my files. The x axis time values: 1 2 3 4 5 6 7 8 9 10 11 12 13 are appearing in some graphs as 1 2 3 4 5 6 7 8 9 1 1 1 1 All the graphs's axes label source is the same set of cells. Changing the cells to different ones makes no difference, the difference seems to be in each graph's settings. In some other graphs I am getting a similar problem, the numbers 1-31 having the 20s appear as 2s. Interestingly if the axes is formatted as a number to 2 decimal places (in the faulty graphs) you end up w...

Graffic converters
Hi i have scanned in some photos using canon D1250u2f scanner and have saved them as jpeg. When i am in publisher and use the insert picture from file it tells me, Publisher cannot convert this picture.This is because either publisher does not recognise the format, or there was an error loading the graffic converter.So on and so on..... I have reloaded all graffics filters and am still unable to insert this picture into publisher. Any ideas whats going wrong? I have downloaded the latest drivers for the scanner but do not want to spend hours downloading all the office updates. Is th...

Number of doubts in VC++
I had a couple of doubts: 1.) I was going thru MSDN and came across this convention: virtual HRESULT STDMETHODCALLTYPE Load( /* [unique][in] */ IStream __RPC_FAR *pStm); Here what does [unique][in] stand for? Some of them have it as /* [out] */, /* [in] */ , etc. What do these mean? 2.)This is a naming convention question. typedef struct _SCOPEDATAITEM { DWORD mask; LPOLESTR displayname; int nImage; int nOpenImage; UINT nState; int cChildren; LPARAM lParam; HSCOPEITEM relativeID; HSCOPEITEM ID; } SCOPEDATAITEM, *LPSCOPEDATAITEM; What does it mean when a name be...

Purchase Request to Purchase Order Error: Vendor Item Number error
This group has been great for helping me fix other errors, but I've only seen one post about this subject which is starting to give us trouble in our 3.0 system. The error says words to the effect that I must supply a vendor ID number, but one clearly exists in the purchase request. In this case the item number is this: GRAD-RENTAL EXPENSE. The other posting referred to the possibility that a vendor item number could be too long for the portal, but this ereq, and others like it, get all the way to the top of the approval tree before we run into a problem. I know how to clear locks and chec...

report -> price history source & 3-decimal numbers
installed money 2003 standard this last april2003. got all investments setup in price history report with [date] as [year-to-date]. rows/columns set with source fields picked. a black dot shows up at each buy date EXCEPT buy dates AFTER the original money install date. what is happening here?.....how to get dots to appear after install date.? transactions activity are listed as [add shares] on 1/2/2003 and [buy] on monthly buy dates. also on the [home] page the share prices in best/worst performers & summary lists are shown in 3-decimal places. how to change these to 2-d...

Excel
Is there a way to change an imported number such as: 7042626598 and display it as a phone number like: (704) 262-6598 ? Thank you, Be -- Message posted from http://www.ExcelForum.com Ben, Yes you can format the cells containing the 10 digit number to a phone number. Highlight all the required cell and on the Main menu choose Format/Cells/Number/Special/Phone Number Charlie O'Neill >-----Original Message----- >Is there a way to change an imported number such as: > >7042626598 and display it as a phone number like: > >(704) 262-6598 > >? > > >...

Convert uppercase to lowercase
Does anyone have a bit of code to convert a file of conatcts all in UPPERCASE to Lower Case? Mervyn Thomas;593677 Wrote: > Does anyone have a bit of code to convert a file of conatcts all in > UPPERCASE to Lower Case? Code: -------------------- For each cll in selection.cells cll.value = lcase(cll.value)' either this line or the next 'cll.Value = Application.WorksheetFunction.Proper(cll.Value) next cll -------------------- -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: ...

Add CRM case number in all emails sent from CRM Case.
Hallo All, Could anyone help me to get CRM Number under CRM Email Subject. Regards, Syed. Hi, This is what we have used in email entity OnLoad event. You can modify to make it suitable for your requirement. var FORM_TYPE_CREATE = 1; var ENTITY_TYPE_INCIDENT = 112; if (crmForm.FormType == FORM_TYPE_CREATE) { if (window.opener) { var oParentCrmForm = window.opener.document.all.crmForm; if (oParentCrmForm && oParentCrmForm.ObjectTypeCode == ENTITY_TYPE_INCIDENT) { var caseNumber = oParentCrmForm.all.ticketnumber.DataValue; crmForm.all.subje...

monthly mortgage payment calculator
I tried to make a mortgage calcultor but my numbers do not jive with the realtors web sites. My formula= (100,000*.06)/12 does not include the interest so my calculations were too low. How would I figure out a monthly payment for a \$100,000 loan at 6% over 30 years? Is there a special formula? Thanks. -Raza Try this: www.officearticles.com/downloads/mortgagecalculator.zip I created it for a "real" realtor, so I assume it's accurate. ************ Anne Troy www.OfficeArticles.com "Raza" <Raza@discussions.microsoft.com> wrote in message news:DA2C6192-F31D-4...

How do I convert cc's to a distribution list group?
Hi; I have received email as part of a 40 person cc and want to create my own distribution list of those other cc's so I can originate messages to the group (and not just use the 'reply all' key). Is there a way to move the cc's from the header of an incoming email directly into a new distribution group with out having to first make each of them a separate contact and then move the contact into the distribution group? Any help would be GREATLY appreciated. Howard Howard M. Rensin <hrensin@comcast.net> wrote: > I have received email as part ...

Convert DST to STD Time on the Fly?
For a database in the U.S. that sees a lot of analysis, I've decided that a little reduncancy is a good thing. Our field crews record DST when it is in effect, but our analysts would usually like to use Standard Time. So I've decided that it's better to have a field for each, and have the form code do the conversion at data-entry time. But I've taken several runs at coding this, and always get to a point where I realize my approach isn't going to work. I'm guessing others have preceded me. Anyone care to throw something in here? -- Thanks, croy Instead of saving...

Sorting by number in a non-numeric field
Hi guys.. so question.. Say I have a row with example: Building1-PC1 Building2-PC1 Building3-PC1 Building1-PC2 Building2-PC2 Building3-PC3 Building1-PC100 Building2-PC100 Building3-PC100.. Desired result from a sort.. Building1-PC1 Building1-PC2 Building1-PC3 Building2-PC1 Building2-PC2 Building2-PC3 Building3-PC1 Building3-PC2 Building3PC-3 Now how do I get there? :P -- kronik ------------------------------------------------------------------------ kronik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31541 View this thread: http://www.excelforum.com/s...

New numbers not included in totals
I don't know what is happening - but I have several columns with sum(A2:A13, B2...)in row 14. When I enter data for the next month within A, Row 14 does not change. If I enter =sum(a2:a13) in another cell (row 16, for instance), it totals all the cells. But - if I enter numbers in another cell in row A, neither row 14 or 16 reflects the additional data to summarize. The only thing I've done is added Chip Pearson's Rowliner. TIA, Carole O Hi try: Tools - Options - Calculate and enable automatic calculation -- Regards Frank Kabel Frankfurt, Germany Carole O wrote: >...

A reducing number by given dates
Hi all, basically what im trying to create is a spreadsheet showing ho many payments i have left on an item i purchased. Now i pay \$100 o this item on every 2nd friday. So my question is, what is a formul that will look at todays date and reconise that it is the second frida when payment is due and reduce a given figure in a cell by \$100. Fo example, Total cost is \$1000, payments = \$100, payments are due o 07/10/05, 21/10/05, 04/11/05 etc So when the 07/10/05 arrives tota cost will = \$900, when 21/10/05 arrives total cost will = 800 etc Obviously when the date is other than specified the tota...

Not able to find pdf converter option in Outlook meny
Have installed Adobe Acrobat standard ver. 8 but still not able to find the PDF converter option in Outlook meny If it causes a problem with Outlook, it will be disabled. You will have to re-enable it in Add-ins. Petter wrote: > Have installed Adobe Acrobat standard ver. 8 but still not able to find the > PDF converter option in Outlook meny ...

converting to email
was wondering how you make a publisher file into an email without it becoming an attatchment. I know it can be done !do i need to go thru another programme? squid wrote: > was wondering how you make a publisher file into an email without it > becoming an attatchment. I know it can be done !do i need to go thru > another programme? ============================== Be aware that due to security settings some of your recipients will receive your newsletter as an attachment no matter how you set it up and may not be able to view the message in the context that was intended. This is why...

Remove decimal but keep entire number
I need the price to display with no decimal, but retaining the numbers that appear after the decimal. For example \$47.50 would be 4750. Example 119.00 would be 11900 Please help -- Tickfarmer in adjacent column multiply by 100. Tickfarmer wrote: > I need the price to display with no decimal, but retaining the numbers that > appear after the decimal. For example \$47.50 would be 4750. > Example 119.00 would be 11900 > Please help > For excel, changing \$47.50 to 4750 is not a "display" issue. You need to multiple it by 100 and put it in anoth...

Number validation
I am having a problem forcing someone to enter a number only between 0 and 100 in a cell. I thought it was relatively simple with data validation, ie whole number between 0 and 100, or using a custom validation like =ISNUMBER(C8). Thia works until someone enters a percentage eg 10%. The cell accepts this as a number and at the same time converts the cell to a percentage format. Is there any way I can allow the entry of a number only between 0 and 100 and not accept the % at the end of the number. Grateful for any guidance. Kind regards Graham Haughs Turriff Scotland Hi one idea use the for...

Converting to PDF
I'm having trouble converting any Office document (mainly Word and PowerPoint) into PDFs. Clicking on the 'Convert to PDF' button tells me that I do not have a PDF printer installed (even though I have a full version of Acrobat Professional CS). The only way I can PDF these docs is to 'print' as a PDF which gives me no output options and I end up with a PDF several times the size of the original document. Can anyone give me a pointer on how to get this problem fixed? I have a PC that works fine (as in the 'Convert to PDF' button generates a nice small PDF, not a g...