Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default How to Create Spreadsheet w/Dates

I am trying to create a spread sheet that will allow me to enter in a date
and the spreadsheet will calculate 10 days from the entered in date and give
me another date, which would be 10 days from the first date.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default How to Create Spreadsheet w/Dates

First date in a cell (let's call it A1)
In second cell =A1+10
Excel stores dates a serial numbers from 1/1/1900
It displays dates in a number of formats
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Hope" wrote in message
...
I am trying to create a spread sheet that will allow me to enter in a date
and the spreadsheet will calculate 10 days from the entered in date and
give
me another date, which would be 10 days from the first date.



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
Need to create a series of dates across a row Equinor Excel Discussion (Misc queries) 4 January 26th 09 05:32 PM
I WANT TO CREATE A FORMULA USING DATES armymatt Excel Worksheet Functions 8 February 12th 08 07:02 PM
Adding Months to Dates to create new value simond Excel Discussion (Misc queries) 3 March 2nd 07 12:31 PM
CREATE A SUM BASED ON DATES Gordon.Ferguson Excel Worksheet Functions 1 August 23rd 05 09:26 AM
how to create dates before 1900 Pieter Excel Worksheet Functions 2 February 3rd 05 09:06 PM


All times are GMT +1. The time now is 10:49 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"