| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 20086 | 2002-05-29 03:15:00 | Calculation of dates inExcel Version 97 | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 51377 | 2002-05-29 03:15:00 | I am designing a form and to make the calculations as easy as possible would like to have progressive dates say starting across columns at 14/5 and moving to the next column 21/5 the the next 28/5 - is there a formula for this or is it quicker just to enter the dates at the top of the columns? *Any* help would be fantastic! | Guest (0) | ||
| 51378 | 2002-05-29 03:56:00 | Hi Sam Just enter the starting date in the first column(say A1), then in the next column '=a1+7' (no quotation marks) where 7 is the increment you want, could be any number of days. You may need to pre-format the cells with the date format of your choice, or format afterwards as you please. Easy isnt it! HTH Trevor |
Guest (0) | ||
| 51379 | 2002-06-08 05:27:00 | Thanks so much Trevor. It was obvious really; form has now been designed successfully. | Guest (0) | ||
| 1 | |||||