Prev: .csv Re-Format Question
Next: Custom Number Format
From: rudyeb on 12 Apr 2010 10:10
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 12 Apr 2010 10:21
=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 12 Apr 2010 10:26
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