| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to go "X" number of days out from a undefined date?
Hi, I need to create a spreadsheet that will show how many days my team has
to complete multiple tasks. Example I need a formula that will take a beginning date "X" and add 20 calendar days to it, then display the new date. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to go "X" number of days out from a undefined date?
One way:
=X + 20 format the cell as a date. In article , Max wrote: Hi, I need to create a spreadsheet that will show how many days my team has to complete multiple tasks. Example I need a formula that will take a beginning date "X" and add 20 calendar days to it, then display the new date. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to go "X" number of days out from a undefined date?
To Excel, dates are just numbers (actually the count of days since DEC 31,
1899 or since DEC 31, 1903 , depending on your settings). And Times are just fractions of days (eg Noon is 0.5) So...if you have a Start Date and you want a date 20 calendar days from that date....just add 20. Example: A1: 01-JAN-2007 B1: =A1+20 Formatted as a date will return 21-JAN-2007 Does that help? *********** Regards, Ron XL2002, WinXP "Max" wrote: Hi, I need to create a spreadsheet that will show how many days my team has to complete multiple tasks. Example I need a formula that will take a beginning date "X" and add 20 calendar days to it, then display the new date. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to go "X" number of days out from a undefined date?
Yes.
Thank you. "Ron Coderre" wrote: To Excel, dates are just numbers (actually the count of days since DEC 31, 1899 or since DEC 31, 1903 , depending on your settings). And Times are just fractions of days (eg Noon is 0.5) So...if you have a Start Date and you want a date 20 calendar days from that date....just add 20. Example: A1: 01-JAN-2007 B1: =A1+20 Formatted as a date will return 21-JAN-2007 Does that help? *********** Regards, Ron XL2002, WinXP "Max" wrote: Hi, I need to create a spreadsheet that will show how many days my team has to complete multiple tasks. Example I need a formula that will take a beginning date "X" and add 20 calendar days to it, then display the new date. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| get a runing total for"curent date"or(cell)minus prev 30 days( cel | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions | |||
| "DAYS 360" and the date Feb 28th as start and end | Excel Worksheet Functions | |||
Hybrid Mode
