# Help with

#### amac

##### New Member
How can we use the Text's Weekly Montly Quarterly and Yearly to calculate and show a date for our new Maintenance. For example if our Date is 11/11/05 and we ad the Text Monthly we should have as our NEW date of Maintenance 12/11/05. We are trying to use the Text's in a list as well.

Cell A1 11/11/05
Cell A2 (list of text ie Weekly, Monthly, quarterly Yearly)
Cell A3 The result shown in ddmmyyyy format

So far we have Define the Text as Numerical values but end up with Errors when using the A3 =SUM(A2+A1) formula

Thanks for any help

### 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.

#### barry houdini

##### MrExcel MVP
Using EDATE from Analysis ToolPak

=IF(A2="weekly",A1+7,EDATE(A1,LOOKUP(A2,{"monthly","quarterly","yearly";1,3,12})))

format as date

or without that addin, an alternative...

=IF(A2="weekly",A1+7,DATE(YEAR(A1),MONTH(A1)+LOOKUP(A2,{"monthly","quarterly","yearly";1,3,12}),DAY(A1)))

Replies
6
Views
147
Replies
1
Views
140
Replies
10
Views
569
Replies
1
Views
237
Replies
7
Views
472

1,195,958
Messages
6,012,541
Members
441,709
Latest member
diurpaneus

### 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