| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with dates please
hello
I have a date in A1 which is a 'start date', 01/02/10 In A2 I have the same date formatted as Mon 01/02/10 using Text(A1,"ddd dd/mm/yy") . no problem In A3, A4 etc I need Tue 02/02/10, Wed 03/02/10 etc etc etc. ie the dates are incrementing by 1 day in each row. Normally I would just add 1 to the date above, but the text formula makes this impossible. help & advice please ?? Thanks as always KK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
| Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
Threaded Mode
