| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
problems adding days to a date
Hi,
I have a field that sums a date plus 14 days and I am getting some very strange results. Any clue? -- Carys |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
problems adding days to a date
What have you got and what strange results are you getting
If there is a 'true' date in A1 (01/01/2006) then =A1+14 will give you 15/01/2006 (UK dd/mm/yyyy) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Carys" wrote in message ... Hi, I have a field that sums a date plus 14 days and I am getting some very strange results. Any clue? -- Carys |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
problems adding days to a date
any formula?
-- Don Guillett SalesAid Software "Carys" wrote in message ... Hi, I have a field that sums a date plus 14 days and I am getting some very strange results. Any clue? -- Carys |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
problems adding days to a date
Strange, like a number somewhere around 39000? If so, you just need to
format the result cell. Either use Format on the menu bar, or copy the original date cell's format using the format painter. "Carys" wrote: Hi, I have a field that sums a date plus 14 days and I am getting some very strange results. Any clue? -- Carys |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| adding only working days to dates | Excel Discussion (Misc queries) | |||
| Conditional formatting based on a date + 30 days | Excel Discussion (Misc queries) | |||
| business days - trade date plus 3 | Excel Worksheet Functions | |||
Linear Mode
