For the life of me, I can't figure this out. The scenario I am trying to calculate is as follows:
I want write a formula that I can insert into O17:O102 that will check if B17:B102 contains either "*HS*","*GRND*","*MAC*", or "*LDDR*" and then propagate a date in O17:O102 that calculates a due date based on a date entered in F7 being, either 1 or 2 years based on the contents i.e. HS and LDDR is 2 years and GRND and MAC is 1 year.
Could/Should this be done with VBA?
I would say if you are calculating it from today and you don't want to hard code that into a cell to use in a formula, then yes you probably want to use VBA to put a value that's not going to change into a cell. Hopefully this is what you mean. If you could post a worksheet with some sample data and show the desired outcome I could be clearer.
So with the worksheet below, I'm saying if you don't like these options and just want a number put into a cell based on using the windows date and being done with it, then VBA.
Last edited by skywriter; 02-23-2015 at 03:04 PM.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Try
=IF(SUM(COUNTIFS(O17,"*"&{"HS","LDDR"}&"*")),EDATE($F$7,24),IF(SUM(COUNTIFS(O17,"*"&{"GRND","MAC"}&"*")),EDATE($F$7,12),""))
Generally speaking (there are exceptions to every rule)Originally Posted by nwb
If it CAN be done without VBA, then it probably SHOULD be done without VBA.
IMHO
Jonmo1 -
Your solution works perfectly! Thank you so much for you help!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks