# Help with formulas with dates

#### lcwilliams

##### New Member
I need a formula that will calculate a certain period of time after a posted date. For example, if D1 says 06/10/08, I need E1 to calculate exactly 9 weeks after that, and F1 to calculate exactly 18 weeks after D1. Can I do that?

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

#### mthompso

##### Board Regular
I need a formula that will calculate a certain period of time after a posted date. For example, if D1 says 06/10/08, I need E1 to calculate exactly 9 weeks after that, and F1 to calculate exactly 18 weeks after D1. Can I do that?

Code:
``````the formula for E1: = D1 + (9*7)
the formula for F1: = D1 + (18*7)``````

Replies
3
Views
268
Replies
3
Views
34
Replies
4
Views
126
Replies
1
Views
180
Replies
5
Views
47

1,191,708
Messages
5,988,232
Members
440,139
Latest member
ngaicuong2017

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back