| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel problem :(
Dear all,
I have following problem with excel. I have date for example 12-04-2006 and i need to do next dates. I know that the date will be 3 mounth later ( this same day ) 12-07-2006 and 12-10-2006 and 12-01-2007 etc etc. How to generate this dates becouse this is very difficult to include by hand ( i have 12,5 thausend records ) and transactions for 10 years. ( 40 dates for one record ) :(((( Thank you for your help Best regards Jarek Krolikowski |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel problem :(
Use the DateAdd function:
newDate = DateAdd("m", 3, oldDate) This adds three months to oldDate and assigns it to newDate. Regards, Steve kicek schrieb: Dear all, I have following problem with excel. I have date for example 12-04-2006 and i need to do next dates. I know that the date will be 3 mounth later ( this same day ) 12-07-2006 and 12-10-2006 and 12-01-2007 etc etc. How to generate this dates becouse this is very difficult to include by hand ( i have 12,5 thausend records ) and transactions for 10 years. ( 40 dates for one record ) :(((( Thank you for your help Best regards Jarek Krolikowski |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel problem :(
One way:
A1: 12-04-2006 A2: =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)) In article .com, "kicek" wrote: I have following problem with excel. I have date for example 12-04-2006 and i need to do next dates. I know that the date will be 3 mounth later ( this same day ) 12-07-2006 and 12-10-2006 and 12-01-2007 etc etc. How to generate this dates becouse this is very difficult to include by hand ( i have 12,5 thausend records ) and transactions for 10 years. ( 40 dates for one record ) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel problem :(
Thank You very much JE McGimpsey napisal(a): One way: A1: 12-04-2006 A2: =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
| Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
| Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
| Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Programming | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
