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 |