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

Got casio qt2000 till, using hospitality 1.35 build 181. Single connection to PC com3:, no printers terminal only and cash draw. Simple single bar senario, Drinks, Read takins and item groups at end...


I think you enter date in std Casio format: PGM1 mode, Type YYMMDD then press X/TIME button
If you go to Z mode and try a report, what happens?
---------------------------------------------------------------------------------
If anyone needs a manual for a Casio QT-2000, C-tech collective have User/ Programming, service manuals here: http://the-checkout-tech.com/manuals/cashregisters/Casio3.php

Dec 01, 2010 | Casio Parts Cash Register PC Desktop

2 Answers

How do i change the time and date on a vivtar 8225


See page 28 of the manual - link below - on how to set the date To Set the date:
  1. Press the Up/Down button to enter the Set Date option.
  2. Press the OK/MENU button.
  3. Press the Right/Left button to select and highlight the Year, Month, Day, Hour, Minute, Second and Date Format type.
  4. Press the Up/Down button to set the Date and Time digits.
  5. Select the first option of the Date format and press the Up/Down button to set the date format that appears on the top line: YY MM DD; DD MM YY; MM DD YY.
  6. Press the OK/MENU button to confirm, save the changes and exit.
The support site for that camera is here http://www.vivitar.com/products.php?dircat=1&dirsubcat=24&dirprod=14&page=downloads Direct link to the user manual http://www.vivitar.com/products/14/ViviCam_8225_Camera_Manual.pdf

Apr 08, 2010 | Cameras

1 Answer

Settings on the date and the year


Hi,

To Set the date:

1. Press the Up/Down button to enter the Set Date option.
2. Press the OK/MENU button.
29
3. Press the Right/Left button to select and highlight the Year, Month, Day, Hour, Minute, Second and Date Format type.
4. Press the Up/Down button to set the Date and Time digits.
5. Select the first option of the Date format and press the Up/Down button to set the date format that appears on the top line: YY MM DD; DD MM YY; MM DD YY.

Mar 28, 2010 | Vivitar Vivicam 8225 Digital Camera

1 Answer

How do I turn on the date stamp feature?feature


on a Kodak dx6490 - you will need to go into the menu, choose the time stamp icon, then choose whether you want yy/mm/dd, or dd/mm/yy, or mm/dd/yy.
if you turn off the time stamp , you must choose one of the above options before it will turn on again. hope this helps 8^)

Oct 13, 2009 | Cameras

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

To set time and date on toshiba


What Toshiba system do you have?
CTX Programming
--(time set)ctx-intercom #652 HH MM SEcs #
--(date change)-intercom #651 YY MM DD #
DK Programming
From Reception phone only
--(time set)DK- intercom #652 HH mm SECs redial
--(date Change)- intercom #651 yy mm dd redial

Jan 10, 2009 | Toshiba DKT2010SD Phone

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

1 Answer

Setting the time


Go to Settings ---> date and time

Set date format: MM/DD/YY or DD/MM/YY

Set date: Day / Month / Year

Set time format: 12 Hr / 24 Hr

Set time: Hour / Minute / Second

Feb 27, 2008 | Philips GOGEAR SA6045 MP3 Player

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

101 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 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...