Question about Microsoft Excel for PC

1 Answer

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

×

Ad

1 Answer

  • 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

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

My passport expires on the 14th July 2017. I am flying with you on 1st June to the UK from the Rep. of Ireland and returning on the 6th June 2017. Is my passport ok to travel on with you.


first off we dont have planes this is fixya ---and with regards to passport as long as you have no restrictions and return before 14 th of july should be good

May 30, 2017 | The Computers & Internet

1 Answer

How do I remove the battery from a 2014 Ski Doo 900 ace snowmobile?


About 26,400 results (0.92 seconds) Search Results

    Brp Expert Tips For Summer Snowmobile Storage ' Ski-Doo ...

    xteam.ski-doo.com/en.../brp-expert-tips-for-summer-snowmobile-storag...
    Apr 4, 2013 - BRP Expert Tips for Summer Snowmobile Storage ... If you have a 1200 4-TEC or ACE 600, change the engine oil and filter. ... SnowTech's First Impressions of the ACE 900 Engine .... September 2014 (4); August 2014 (1); July 2014 (1); April 2014(2); March 2014 (6); February 2014 (14); January 2014 (5) ...

    First oil change opinions - 900 ACE 4-Stroke Models - DOOTalk ...

    www.dootalk.com/forums/topic/671977-first-oil-change-opinions/
    Dec 15, 2013 - Page 1 of 4 - First oil change opinions - posted in 900 ACE 4-Stroke ... suppose to be easier on the 2014 , different battery bracket ? or you can ... 900 Ace Summarization ??? - 900 ACE 4-Stroke Models
    Apr 1, 2014
    900 ACE no power at outlet - GPS Talk
    Jan 15, 2014
    2013 Skandic WT 600 ACE - Skandic / Expedition
    Dec 22, 2012
    Battery Removal - Skandic / Expedition
    Apr 12, 2012
    More results from www.dootalk.com

Jan 24, 2016 | Ski-Doo 2014 GSX LE 900 ACE

1 Answer

Hello, i am trying to find out when the MDE6400AYA was made.. What year


Hello there.

You will need to write down your SERIAL number from your model/serial tag.
Example: 15114672UY...... UY is the date code. First letter is the year, second letter-month.

1980 E March
1981 G April
1982 J May
1983 L June
1984 N July
1985 P August
1986 R September
1987 T October
1988 V November
1989 X December
1990 B Jan.
1991 D Feb.
1992 F March
1993 H April
1994 K May
1995 M June
1996 Q July
1997 S Aug.
1998 U September
1999 W Oct.
2000 Y Nov.
2001 Z Dec.
2002 A Jan.
2003 C Feb.
2004 E Mar.
2005 G April
2006 J May
2007 L June

Hope that helps,


Mike

Jul 27, 2011 | Maytag Atlantis MDE7400AY Electric Dryer

1 Answer

How do I change the date format? I live in Australia and we put the day first than the month ie 1 June is listed 1 6 (not 6 1 like in the USA). As I write this (on the 4 July) my watch is saying '7 4'...


mcdevito75 here, Heelo Dave, I don"t think the Format can be changed the watch was built to show the --either month or day of the week first then the date, example, July 4 Or Sat. 4

Jul 04, 2010 | Citizen Blue Angels Skyhawk Watch

1 Answer

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.

Dec 27, 2008 | Microsoft Office Standard for PC

1 Answer

Excel support


Hi,
Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.

First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.

Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970
The next cell down has a value of ='DataRecord'!B971 and so and on until B974

My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.

Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.

All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity.
The graphs are automatically updated with the data each time the macro is run.

You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to.
Hope this helps.
Glad to be of assistance - please rate the solution I can learn from you. Thanks

Oct 24, 2008 | Microsoft Office 2003 Basic Edition...

1 Answer

Need to get a report of sent faxes for the month of June and July.


Fax machines only keep the last 20 transactions, usually.

Look for "JOURNAL PRINT" in the menus.

Oct 06, 2008 | Panasonic KX-FHD331 Plain Paper Thermal...

1 Answer

Horizontal


Not sure if I get your problem. Do you mean the SUM() formula with the row does not work?
That is the simplest solution if you are entering the monthly numbers per month.

If you have all these values and need to sum them up based on the current month, you need to use the MONTH() with the NOW() formulas to get a month offset and use a relative reference for the SUM() formula.

Jun 23, 2008 | Microsoft Excel for PC

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

362 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2679 Answers

Peter Dragonetti

Level 3 Expert

798 Answers

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

Answer questions

Manuals & User Guides

Loading...