| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date in 5 weeks from entered date
What is the formula that would allow me to enter a date in one cell
(B1) and have B3 show the date 5 weeks from the date entered? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date in 5 weeks from entered date
=b1+35
Make sure the cell is formatted as a date. rudyeb wrote: What is the formula that would allow me to enter a date in one cell (B1) and have B3 show the date 5 weeks from the date entered? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date in 5 weeks from entered date
Hi
=B1+35 5 weeks * 7 days -- Regards Roger Govier rudyeb wrote: What is the formula that would allow me to enter a date in one cell (B1) and have B3 show the date 5 weeks from the date entered? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate a date, 10 weeks after a set date & return a specific da | Excel Worksheet Functions | |||
| Counting Closed Date < 2 weeks of Open Date etc | Excel Worksheet Functions | |||
| Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
| calculate a date, 10 weeks after a set date | Excel Worksheet Functions | |||
| calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
Hybrid Mode
