Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
SSJ SSJ is offline
external usenet poster
 
Posts: 58
Default 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
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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
Formula:
=A1+(B1*7
, which would return the date 3/26/2021 (the end of week 12).
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,118
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
SSJ SSJ is offline
external usenet poster
 
Posts: 58
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
excel date scheduling not msProject 4pinoy Excel Worksheet Functions 0 November 11th 06 09:33 PM
Date in middle of month Sunnyskies Excel Discussion (Misc queries) 10 October 23rd 06 03:23 PM
Determining Date X based on Other dates MIchel Khennafi Excel Worksheet Functions 1 May 3rd 06 04:45 PM
calculate weeks from a start date ( not yr weeks) Todd F. Excel Worksheet Functions 6 November 27th 04 06:53 PM


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"