date column

  1. A

    Date Formatting

    Dear All, Good Day! I am very new to this forum, and this is my first post here. My problem :- we are using a excel 2007 file in which we have to fill date in it in dd/mm/yyyy format. we format the whole column in this format. when we enter the date it save it correct format but after some...
  2. R

    Excel converts .csv imported date field into mm/dd/yyyy format

    I'm importing data from a comma separated text file into excel. The date in the original text file is presented as 2010-02-02, however when it gets imported into excel as a csv file, the date's formatting changes automatically to 02/02/2010, which I think is clever and cool. However, when I...
  3. C

    That crazy IT dept. . .

    My IT dept sent me a table with a column of dates entered as either 5 or 6 characters, (ex. 101309 = Oct 13, 2009 and 90409 = Sept 4, 2009). Excel NOT happy to convert to a date format. Is there a formula I can use to convert these to a conventional date format?
  4. K

    Subtotaling based on date in a column

    I am trying to create a subtotal in Column L for the values in Column K that all have the same date in Column A. All of the Dates in Column A are in chronological order. No dates are out of order. Example A1 = 11/2/2008 : K1 = 22.00 A2 = 11/2/2008 : K2 = 25.00 A3 = 11/4/2008 : K3 = 12.50 A4 =...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top