Microsoft Excel for PC Logo
Posted on Dec 27, 2008

DATE DIFERANCE BETWEEN SELECTED COLOUMN

02/04/08
05/04/08
04/06/08
08/05/08
10/07/08
05/07/08

ABOVE COLUMN 4 TH MONTH =APR, 5 TH MONTH=MAY.....

I MEAN I FOUND APR. MAY. JUNE JULY ETC...
PLESAE HELP ME AND OBLIGE.
THAKOR PATEL GUJARAT INDIA


  • Anonymous May 11, 2010

    Are you trying to figure out how many days in-between those dates? And are those dates in MM/DD/YY or DD/MM/YY format?

×

1 Answer

Anonymous

Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

  • Contributor 36 Answers
  • Posted on Dec 30, 2008
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

Joined: Dec 30, 2008
Answers
36
Questions
0
Helped
13033
Points
46

Are you trying to figure the difference in days between these dates and one single date (Dec. 31, 2008 for example)?

Whatever you're trying to do, here is the formula, assuming you're starting in A1:
Put the first date in the format Day-Month-Year in numbers (Sept. 3 is 03-09-2008)
Then put your other date in B1, in Day-Mo-Yr format (31-12-2008 for Dec. 31, 2008)
In C1 put B1-A1 and that will give you the number of days between those two dates.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
2answers

I have a Westinghouse stove I need to find the age please.

The 4 th and 5 th numbers on the serial number show the Year . You can fine this google your stove and how to age
1helpful
1answer

Nissan x trail set time clock

https://www.nissan.co.il/content/dam/Nissan/israel/services/car-books/Nissan-Xtrail-Car-Book-2016-ENG.pdf

Page 4-5

Clock:
Select the corresponding keys to adjust the settings.
• Time Format:
The time setting can be selected from 12 hour
and 24 hour formats.
• Date Format:
The day, month and year display can be selected
from five formats.
• Clock Mode:
Select the clock mode from Manual, Time Zone
and Auto.
When [Manual] is selected, you can set the clock
mode manually from the [SET CLOCK MANUALLY] screen.
Select [Auto] to automatically maintain the time
using GPS.
• Set Clock Manually:
Mode (AM/PM) (where fitted), Hours, Minutes,
Day, Month and Year can be set manually if
[Manual] is selected in the Clock Mode setting.
• Daylight Savings Time:
Turns the daylight savings time on or off.
• Time Zone:
Select the applicable time zone from the list.
0helpful
1answer

Mfg date

Every Dell part has a label with a long serial number in the following format:
CC-PPPPPP-MMMM-DDD-SSSS

CC= 2 letters, country of origen (e,g, TH for Thailand, CN for China).
PPPPPP= 6 alphanumeric, Dell internal part number, most times starts with 0.
MMMMM= 5 numbers, Vendor ID.
DDD= Manufacturing date code
first digit= number, manufacturing year (e.g 8=2008, but on old stuff could be 1998)
second digit= alphanumeric, manufacturing month (1=January, 9=September, A=October, C=December)
Third digit= alphanumeric, manufacturing day of the month (1=1, 9=9, A=10, B=11,....and so on).
SSSS= 4 alphanumeric, serial number.

Not sure what date code you are looking at unless a "Plain Language Request" was made for that series in which case it would have been manufacturered 2020 - February (02) - 19th. Not a lot of these and I have never seen them on Dell but I guess anyting is possible
0helpful
1answer

How to set date

from the manual:
"4. to change the calendar, press and hold the date/7-5-2 button until the display shows the flashing year.
5. Press the Reverse and Forward buttons to set the current year. When you have selected the year, press the Enter Button, then use the Reverse and Forward Buttons to set the month/day.
6. After you have set the date, press the Enter button or wait for the display to beep twice and lock into place."

Hope this helps. My model is T307
0helpful
1answer

I have a double pol 208 dgm100 and i conect whith contactor and i cant able to program please can you help

Tork digital timers and manuals appears on following link
http://waterheatertimer.org/Tork-Digital-timers-and-manuals.html#DGM

DGM100 programming manual:
http://waterheatertimer.org/pdf/TORK.DGM100.INSTALL&OP.pdf

DGM100 is single channel timer, so timer operates all Loads at same time.
In other words, if you have 2 different contactors, the timer cannot set different schedules for each.

7-day programming
32 set points

Programming buttons:
geno_3245_224.jpg
1) When powering up the unit, model number 100P appears on screen.
LCD displays 12H which is an automatic (AM/PM) format.

Press ENTER to keep 12hour am pm -or- press HOUR to change to military time, and then press ENTER

2) Unit is in RUN mode and time displays.

3) Set current time:
Press DAY/Month key to select current Day.
Press HOUR key to set current hour (with AM/PM).
Press MIN key to set current minutes.
Press ENTER key to confirm.
Unit now stores present time. Seconds are set to zero.

4) Daylight savings time (DST) automatically adjusts for daylight savings time, if you choose this option.
In step 3 you set current time, but you did not set the Month and date.
YES DST: If you want DST then follow step 5 and enter Month and date.
NO DST: If you don't want DST, then skip Month and date, and move forward to step 6

5) Set month and date.
Press MODE until DATE displays
Press Month button to set current month
Press Date button to set current date
Press ENTER to confirm

6) Set programs
Press MODE key until SET displays

Display shows --:-- 01 which is program1
-Press DAY/MONTH key to set day(s) you want program1 to turn ON
Following are choices that display on screen:
MO to FR (MO, TU, WE, TH, FR)
SA and SU (SA, SU only)
MO to SA (MO, TU, WE, TH, FR, SA)
SU to SA (SU, MO, TU, WE, TH, FR, SA)
Individual days: SU, MO, TU, WE, TH, FR, SA, and D
for Special Day (usually a holiday).
-Press HOUR key to set hour {check AM/PM} you want program1 to turn ON.
-Press MIN key to set minutes you want program1 to turn ON.
-Press ON/OFF button to select ON, and then program1 will turn ON at your set schedule.
Press ENTER to confirm setting.

Display now shows --:-- 02 which is Program2
-Press DAY/MONTH key to set day(s) you want program2 to turn OFF
Choose same days you chose for Program1 ON so timer does not have conflicting programs.
-Press HOUR key to set hour {check AM/PM} you want program2 to turn OFF
-Press MIN key to set minutes you want program2 to turn OFF
-Press ON/OFF button to select OFF, and then program2 will turn OFF at your set schedule.
Press ENTER to confirm setting.

Continue setting up to 32 different programs.
When finished programming, press MODE button until RUN appears

Manual shows more programming options such as override, reviewing programs, setting special days.

Add a comment for more free help.
Also take advantage of fixya phone service.
For a price, fixya expert speaks with you over phone while you work on timer.
0helpful
1answer

Creating vacation accrual spreadsheet

Here is one way to do it:
1. In column A enter the name
2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)
3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)
4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)
5. In column E, put this formula:
(D2/30)*1.25 (assuming this is line 2)
You can then copy these lines as many times as you need to, total them, etc.
1helpful
1answer

CANNON SURE SHOT 80U

1. With power off, press the MODE button to select the DATE mode.
2. Press the zoom out (three trees) button for more than two seconds to enter the date/time set mode.
3. Press the zoom out (three trees) button to select year, month, day, hour, or minute (selected number will flash).
4. Use the zoom in (one tree) button to advance the number.
5. Repeat steps 3. and 4. to set each value.
6. Press the zoom out (three trees) button until the colon (in the hours:minutes) is flashing. When the colon stops flashing, date and time setting is completed.
7. Press the MODE button and the power will switch off.
5helpful
1answer

Need to set the date and can't find manual--

Try this:
1. With power off, press the MODE button to select the DATE mode.
2. Press the zoom out (three trees) button for more than two seconds to enter the date/time set mode.
3. Press the zoom out (three trees) button to select year, month, day, hour, or minute (selected number will flash).
4. Use the zoom in (one tree) button to advance the number.
5. Repeat steps 3. and 4. to set each value.
6. Press the zoom out (three trees) button until the colon (in the hours:minutes) is flashing. When the colon stops flashing, date and time setting is completed.
7. Press the MODE button and the power will switch off.
1helpful
1answer

Date and time

1. With power off, press the MODE button to select the DATE mode.
2. Press the zoom out (three trees) button for more than two seconds to enter the date/time set mode.
3. Press the zoom out (three trees) button to select year, month, day, hour, or minute (selected number will flash).
4. Use the zoom in (one tree) button to advance the number.
5. Repeat steps 3. and 4. to set each value.
6. Press the zoom out (three trees) button until the colon (in the hours:minutes) is flashing. When the colon stops flashing, date and time setting is completed.
7. Press the MODE button and the power will switch off.
0helpful
1answer

Setting the Clock

1.In the stop mode, press and hold down the MENU/STOP button for at least 2 seconds
The menu setting display appears.
2. Press the SKIP/SEARCH button repeatedly to select dAtE
3. Press the POWER/PLAY button.
The year display blinks
4. Press the SKIP/SEARCH button repeatedly to select the year. Then press the POWER/PLAY button. The month display blinks.
5. Repeat the same step 4 to set the month, day, hour display ("24 H or "12H") hour and minute. Note: "second" cannot be selected.
When the minute setting is completed, "dAtE" returns.
6. Press the MENU/STOP button.
Not finding what you are looking for?

400 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

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

Answer questions

Manuals & User Guides

Loading...