From: rudyeb on
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?
From: Dave Peterson on
=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
From: Roger Govier on
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?
 | 
Pages: 1
Prev: .csv Re-Format Question
Next: Custom Number Format