Question about Microsoft Office Excel 2003 for PC

# 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

• 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

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.

Posted on Mar 12, 2009

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).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### 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"

Jun 23, 2011 | Microsoft Excel for PC

### 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

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

Apr 08, 2010 | Cameras

### Settings on the date and the year

Hi,

To Set the date:

1. Press the Up/Down button to enter the Set Date option.
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

### 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

### 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

### 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

### 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

### 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

## Open Questions:

#### Related Topics:

101 people viewed this question

Level 3 Expert

Level 3 Expert