Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering historic dates
Sorry if this is a very basic query ...
I have to enter a large number of dates into a spreadsheet during the period 1972 - 1976. Obviously, if you just enter a date into Excel using the keystrokes 28/6, it assumes that you are referring to the current year. As I will be entering the data in chronological order, how can I avoid having to type 28/6/1973, 1/7/1973, 5/7/1973, etc all the time? Is there a way I can get Excel to treat all the dates as being in a particular past year ... or can I enter them all as this year and then change them in blocks somehow? Any advice appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering historic dates
No, Excel will always select the current year
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Terry Bennett" wrote in message ... Sorry if this is a very basic query ... I have to enter a large number of dates into a spreadsheet during the period 1972 - 1976. Obviously, if you just enter a date into Excel using the keystrokes 28/6, it assumes that you are referring to the current year. As I will be entering the data in chronological order, how can I avoid having to type 28/6/1973, 1/7/1973, 5/7/1973, etc all the time? Is there a way I can get Excel to treat all the dates as being in a particular past year ... or can I enter them all as this year and then change them in blocks somehow? Any advice appreciated! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering historic dates
Hi, Terry
try to put in a2 (eg) 28/06/1973 on a3 put =a2+1 (and excel will return 29/06/1973) copy it down format as you need hth regards from Brazil Marcelo "Terry Bennett" escreveu: Sorry if this is a very basic query ... I have to enter a large number of dates into a spreadsheet during the period 1972 - 1976. Obviously, if you just enter a date into Excel using the keystrokes 28/6, it assumes that you are referring to the current year. As I will be entering the data in chronological order, how can I avoid having to type 28/6/1973, 1/7/1973, 5/7/1973, etc all the time? Is there a way I can get Excel to treat all the dates as being in a particular past year ... or can I enter them all as this year and then change them in blocks somehow? Any advice appreciated! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering historic dates
You could adapt this macro to fit your needs
http://www.cpearson.com/excel/DateTimeEntry.htm -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Peo Sjoblom" wrote in message ... No, Excel will always select the current year -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Terry Bennett" wrote in message ... Sorry if this is a very basic query ... I have to enter a large number of dates into a spreadsheet during the period 1972 - 1976. Obviously, if you just enter a date into Excel using the keystrokes 28/6, it assumes that you are referring to the current year. As I will be entering the data in chronological order, how can I avoid having to type 28/6/1973, 1/7/1973, 5/7/1973, etc all the time? Is there a way I can get Excel to treat all the dates as being in a particular past year ... or can I enter them all as this year and then change them in blocks somehow? Any advice appreciated! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering historic dates
Thanks for the suggestions guys!
"Peo Sjoblom" wrote in message ... No, Excel will always select the current year -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Terry Bennett" wrote in message ... Sorry if this is a very basic query ... I have to enter a large number of dates into a spreadsheet during the period 1972 - 1976. Obviously, if you just enter a date into Excel using the keystrokes 28/6, it assumes that you are referring to the current year. As I will be entering the data in chronological order, how can I avoid having to type 28/6/1973, 1/7/1973, 5/7/1973, etc all the time? Is there a way I can get Excel to treat all the dates as being in a particular past year ... or can I enter them all as this year and then change them in blocks somehow? Any advice appreciated! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering historic dates
Hi Terry
You could enter all your dates as the current year in column A. Then in B1 enter =DATE(1973,MONTH(A1),DAY(A1)) and copy down as far as required. Copy all of the data in column B and Paste SpecialValues to "fix" the data as 1973. Repeat process for other year's required. -- Regards Roger Govier "Terry Bennett" wrote in message ... Sorry if this is a very basic query ... I have to enter a large number of dates into a spreadsheet during the period 1972 - 1976. Obviously, if you just enter a date into Excel using the keystrokes 28/6, it assumes that you are referring to the current year. As I will be entering the data in chronological order, how can I avoid having to type 28/6/1973, 1/7/1973, 5/7/1973, etc all the time? Is there a way I can get Excel to treat all the dates as being in a particular past year ... or can I enter them all as this year and then change them in blocks somehow? Any advice appreciated! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering historic dates
Sounds good Roger - many thanks
"Roger Govier" wrote in message ... Hi Terry You could enter all your dates as the current year in column A. Then in B1 enter =DATE(1973,MONTH(A1),DAY(A1)) and copy down as far as required. Copy all of the data in column B and Paste SpecialValues to "fix" the data as 1973. Repeat process for other year's required. -- Regards Roger Govier "Terry Bennett" wrote in message ... Sorry if this is a very basic query ... I have to enter a large number of dates into a spreadsheet during the period 1972 - 1976. Obviously, if you just enter a date into Excel using the keystrokes 28/6, it assumes that you are referring to the current year. As I will be entering the data in chronological order, how can I avoid having to type 28/6/1973, 1/7/1973, 5/7/1973, etc all the time? Is there a way I can get Excel to treat all the dates as being in a particular past year ... or can I enter them all as this year and then change them in blocks somehow? Any advice appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering items on specific dates of year | Excel Discussion (Misc queries) | |||
Entering DATEs in EXCEL should not require use of "/" slashes. | Excel Discussion (Misc queries) | |||
Entering dates in Excel 2002 | Excel Discussion (Misc queries) | |||
entering and updating dates on a spreadsheet | Excel Worksheet Functions | |||
Entering dates QUICKLY | Excel Discussion (Misc queries) |