Thread: Date in 5 weeks from entered date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote