ExcelBanter - Date in 5 weeks from entered date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date in 5 weeks from entered date (https://www.excelbanter.com/excel-discussion-misc-queries/261268-date-5-weeks-entered-date.html)

rudyeb

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?

Dave Peterson

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

Roger Govier[_8_]

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?

All times are GMT +1. The time now is 06:32 AM.