LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,091
Default Calculating dates

Excel's dates are numbers. Excel's date range is Jan. 1, 1900, day 1 through
Dec. 31, 9999, day 2,958,465. March 18, 2008 is day 39,525. When you format
the number 39525 as mm/dd/yy you will see 03/18/08. So, since Excel's dates
are simply numbers, you can do anything with them that you can do with
numbers.

Tyro

"countrygirl0712" wrote in
message ...
I want column a to take column b and come up with the date that would be 7
days after the date in col b. Is there any way to do that? Thanks for
any
help you can give me.



 
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
Calculating Dates Anne Excel Worksheet Functions 6 February 7th 08 12:56 AM
CALCULATING DATES spudpeeps New Users to Excel 3 December 6th 07 11:40 AM
calculating dates spudpeeps New Users to Excel 2 December 5th 07 07:53 PM
Calculating number of days between two dates that fall between two other dates [email protected] Excel Discussion (Misc queries) 5 October 26th 05 06:18 PM
Calculating dates Bob Phillips Excel Discussion (Misc queries) 1 March 18th 05 09:21 AM


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