Question about Microsoft Office Excel 2003 for PC

1 Answer

Calculation of end date in format dd/mm/yy

What is the formula,if a cell having start date of some batch, and i f i need to calculate the date after 15 month ?

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 80 Answers

Assuming you put the start date in cell A1, put this formula:

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

in the cell where the result wanted to be appeared.

P.S.: If this information was helpful, please rate this solution.

Posted on Mar 12, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I need a formula length of service in DD/MM/YY on MS Excell


Format cells A1 and B1 to dates.

A1 is the first date
B1 is the 2nd date
C1 enter the formula below

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

rootmailsd.jpg

Jun 23, 2011 | Microsoft Excel for PC

1 Answer

Need a formula to calculate length of service in excel


You could do a simple +NOW-START DATE

It would depend on the format of your start dates - i.e YY, DD/MM/YY as to the results you get.

Do want the results in years, months, days?




Jun 05, 2009 | Microsoft Excel for PC

1 Answer

Wages bill reg


Format both cells with the time format "h:mm AM/PM".
Lets say the start time is in cell A2 and the stop time is in cell B2. In cell C2 put the formula =B2-A2 and custom format the cell C2 as: "h:mm"

Apr 16, 2009 | Microsoft Excel for PC

1 Answer

What is the formula,if a cell having start date of some batch, and i f i need to calculate the end date after 15 month ?


Use this forumla =EDATE(A1,15)

example in cell A1 you enter 3/11/2009 and in cell A3 you enter=EDATE(A1,15)

You will first see a serial number representing the new date. You must format cell A3 to display the value as a date. it should be:
6/11/2010

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Need to Add Dates in Excel


Here is one way I just tried:

Say the date purchased is in A1.

You want the Est Life in A2.

In A2 type: =A1+(3*365)
That will add 3 years.

For 5 years: =A1+(5*365)

Try it out!

Note: You will need to format the cells to Custom>mm/dd/yyyy

Nov 21, 2008 | Microsoft Excel for PC

1 Answer

How to calculate total downtime of a perticulor ticket. for ex: if a perticulor ticket being opened three days before and the end time would be 4th or 5th day, so the ticket details would be containing,...


cell 1 = logged in date <mm/dd/yy>
cell 2 = logged in time <hh:mm:ss>
cell 3 = resolved date <mm/dd/yy>
cell 4 = resolved time <hh:mm:ss>
cell 5 = cell 4 + cell 3 - cell 2 - cell 1 <general format>
cell 6 = day(cell 5) <general format>
cell 7 = hour(cell 5)&":"&minute(cell 5)&":"&second(cell 5) <general format>

Nov 18, 2008 | Computers & Internet

3 Answers

Formulas in microsoft excel 2007


Excel 2007 has a rather elaborate formula pull down menu.it out,

Loringh

Nov 12, 2008 | Microsoft Excel for PC

3 Answers

Need excel solution


Hello ycool11, If your asking what i think you are the formula would be
=(a2-a1)*24
That assumes a2 is that last date entered and a1 is the initial starting date. if you would like a more intense formula let me know and i'm sure i can help.

Oct 22, 2008 | Microsoft Excel for PC

1 Answer

Date format in quickbooks 7.4


If it's anything like Excel, someplace in the FORMAT menu should be options to allow you to change the date format. (Block off the cells, row, or column in question, click FORMAT in your toolbar.) You may have different country options or formatting choices within the date type.

Nov 15, 2007 | Intuit QuickBooks Premier: Accountant...

Not finding what you are looking for?
Microsoft Office Excel 2003 for PC Logo

100 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...