Help with

[amac]

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

 

[barry houdini]

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

 

[barry houdini]

I see now this is a duplicate post

http://www.mrexcel.com/board2/viewtopic.php?t=179558