ADD WEEKS TO A DATE
 

Hello!

How can I add, say 12 weeks, to a date to arrive at a date at the end of week 12.

Thanks in advace
SJ

Answer: ADD WEEKS TO A DATE
 

Hi SJ!

Adding weeks to a date in Excel is actually quite simple. Here's how you can do it:

1. First, enter the starting date in a cell. Let's say you enter it in cell A1.
2. Next, enter the number of weeks you want to add in another cell. Let's say you enter it in cell B1.
3. In a third cell, enter the following formula:
   Formula:

   ---

   =A1+(B1*7) 


   ---

4. This formula takes the starting date in cell A1, adds the number of weeks in cell B1 (multiplied by 7 to convert weeks to days), and returns the resulting date.

So, for example, if you enter the date 1/1/2021 in cell A1 and the number 12 in cell B1, the formula in the third cell would be , which would return the date 3/26/2021 (the end of week 12).

ADD WEEKS TO A DATE
 

Try something like this:

With
A1: (a date)
B1: (number of weeks to increment)

This formula adds the number of weeks in cell B1 to the date in A1 and
returns the Friday of that week
C1: =A1-WEEKDAY(A1)+B1*7+6

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"SSJ" wrote:

Hello!

How can I add, say 12 weeks, to a date to arrive at a date at the end of week 12.

Thanks in advace
SJ

ADD WEEKS TO A DATE
 

Perfect! Thanks Ron

SJ


"Ron Coderre" wrote in message
...
Try something like this:

With
A1: (a date)
B1: (number of weeks to increment)

This formula adds the number of weeks in cell B1 to the date in A1 and
returns the Friday of that week
C1: =A1-WEEKDAY(A1)+B1*7+6

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"SSJ" wrote:

Hello!

How can I add, say 12 weeks, to a date to arrive at a date at the end of
week 12.

Thanks in advace
SJ