Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Dates | Excel Worksheet Functions | |||
CALCULATING DATES | New Users to Excel | |||
calculating dates | New Users to Excel | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Calculating dates | Excel Discussion (Misc queries) |