Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default HOW CREATE FORMULA TO ADD THE COLUMN CELLS THAT CONTAINING DATES


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default HOW CREATE FORMULA TO ADD THE COLUMN CELLS THAT CONTAINING DATES

a: A message with a blank content is likely to be rejected or ignored. The
subject line is just for a brief description, and the detail (which is sadly
lacking in this message) should be in the message body.
b: Postings all in UPPER CASE are regarded as SHOUTING, and a breach of
netiquette.
c: Dates within Excel are stored as numbers, so in general it can't
distinguish between a date and another number. You may be able to
distinguish an integer from a non-integer number (which would represent a
date and time). You may be able to define a rule such as dates in the 21st
century or within another window.
d: If you are adding two dates, such as 22 Sep 2007 and 23 Sep 2007, do you
want the result to appear as 16 Jun 2115 or as 78695?

You may wish to reformulate your question?
--
David Biddulph

"krishna" wrote in message
...



Reply
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
How do I create formula to calc difference in dates? dlcroswell Excel Discussion (Misc queries) 21 May 12th 10 10:45 PM
how do I update a column and create new rows for new column cells Pete Excel Discussion (Misc queries) 1 June 6th 07 02:02 AM
Formula to Create Consecutive #s for Non-Linear Dates zee Excel Worksheet Functions 3 September 9th 06 07:35 PM
How can I create a formula to locate data between two dates? A shink Excel Worksheet Functions 3 April 1st 05 02:11 AM
Trying to create repeating dates and then sort column by date lizabright Excel Worksheet Functions 2 February 11th 05 12:33 AM


All times are GMT +1. The time now is 11:14 AM.

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

About Us

"It's about Microsoft Excel"