LinkBack URL
About LinkBacks
if cell b2 has "three months"
if cell c2 has "1-1-15"
what is the formula that would give me the answer "4-1-15" in cell d2?
Screen Shot 2015-02-07 at 6.24.34 PM.png
if cell b2 has "three months"
if cell c2 has "1-1-15"
what is the formula that would give me the answer "4-1-15" in cell d2?
Screen Shot 2015-02-07 at 6.24.34 PM.png
B2 " three months" must be in a text format. Thanks for your help
Format B as a number, and then consistently use it for months. Then try putting this in D2 --
Formula:
=DATE(YEAR(C2),B2+MONTH(C2),DAY(C2))
@ neckty23, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
@ chris, it sounds like B2 contains text (words), formatting as number will have no affect on it
(also, if you just want to add x months to a date, try using =EDATE(c2,x) )
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins thanks for the info! I'll try and add it now. thanks! The file should now be attached
Last edited by neckty23; 02-08-2015 at 12:05 AM.
...IF...you will only ever have weeks or months, try this, copied down...
=IF(ISNUMBER(SEARCH("month",B2,1)),EDATE(C2,LEFT(B2,2)),C2+(LEFT(B2,2)*7))
Awesome! works great. Thanks!
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks