LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 180
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for adding days to a date excluding weekends and holidays? Jake via OfficeKB.com Excel Discussion (Misc queries) 3 May 20th 23 07:48 PM
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
adding only working days to dates bazooka Excel Discussion (Misc queries) 2 May 4th 06 06:15 PM
Conditional formatting based on a date + 30 days Laura4363 Excel Discussion (Misc queries) 5 January 13th 06 11:07 AM
business days - trade date plus 3 clegge Excel Worksheet Functions 2 January 11th 06 04:35 PM


All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"