Question about Microsoft Excel for PC

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

Posted by on

• Peter Sturniolo 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?

×

• 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

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.

Posted on Dec 30, 2008

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).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

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

Aug 26, 2012 | Dell Inspiron All-In-One Computer

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

Sep 15, 2011 | Timex T307ST Clock Radio

How to set the date

Time and date setting
To set time, date, and options:
1) With time and day showing, press and hold SET.
2) City code flashes. Press START/STOP to select city that represents your time zone. See table below
for city codes.
3) Press MODE. DST (daylight savings time) setting flashes. Press START/STOP to select AUTO (obey
setting in radio signal), ON, or OFF (disregarding setting in radio signal for ON/OFF).
4) Press MODE. Hour flashes. Press START/STOP to change hour (including AM/PM); hold button to
scan values
5) Press MODE. Minutes flash. Press START/STOP to change minutes
6) Press MODE. Seconds flash. Press START/STOP to set seconds to zero.
7) Press MODE. Year flashes. Press START/STOP to change year.
8) Press MODE. Month flashes. Press START/STOP to change month.
9) Press MODE. Day flashes. Press START/STOP to change day.
10) Press MODE. Date flashes. Press START/STOP to select M-D (month-day) or D-M (day-month) format.
11) Press MODE. Hourly chime setting flashes. Press START/STOP to select ON/OFF. When ON is
selected, watch chimes on every hour.
12) Press MODE. Button beep setting flashes. Press START/STOP to select ON/OFF. When ON is
selected, watch beeps for every button press.
13) Press SET, at any step, when done setting.
Press and hold MODE to switch between 12- and 24-hour time format.
Press SET to view date. Year is at top of display and date is below.
Press RECEIVE to view current city.
Press and hold RECEIVE to begin manual reception of time signal, as described in ATOMIC CLOCK
SYNCHRONIZATION section.

(from the User's manual)

May 03, 2011 | Timex 1440 Prizefighter 53032 Sports...

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:

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.

Jan 04, 2011 | TORK Timer 1 Channel Signal Timer Dgs100

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.

Dec 27, 2008 | Microsoft Office Standard for PC

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.

Jan 22, 2008 | Canon Sure Shot 80U 35mm Point and Shoot...

How do I change the date? I don't have a manual.

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.

Jan 13, 2008 | Canon Sure Shot Z180u 35mm Point and Shoot...

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.

Dec 22, 2007 | Canon Sure Shot 115u II Date 35mm Film...

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.

Nov 07, 2007 | Canon Sure Shot 80U 35mm Point and Shoot...

Setting the Clock

1.In the stop mode, press and hold down the MENU/STOP button for at least 2 seconds
2. Press the SKIP/SEARCH button repeatedly to select dAtE
3. Press the POWER/PLAY button.
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.

Nov 01, 2007 | Sanyo ICR-B60 Digital Voice Recorder

Open Questions:

Related Topics:

355 people viewed this question

Level 3 Expert

Level 3 Expert