LinkBack URL
About LinkBacks
=IF(B2="T1*", E2+365 days, E2+395 days)
Request help 4 IF/DATE FORMULA
=IF(B2="T1*", E2+365 days, E2+395 days)
Last edited by makmanoj; 12-04-2016 at 08:56 AM.
Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional. Thanks!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for changing the thread title.
Hope you enjoyed your warm welcome to the forums, makmanoj. If I recall mine wasn't much better.
Anyways, if you are adding days (not weekdays) and E2 is a date, then =IF(B2="T1*", E2+365, E2+395) will work. (Are you trying to do something special with the asterisk? A wildcard?)
Like this?
=IF(RIGHT(B2,2)="T1", E2+365 days, E2+395 days)
Phuocam, I think you mean to use LEFT. Also, get rid of "days."
Yes! LEFT function:Originally Posted by JYTS
=E2+IF(LEFT(B2,2)="T1",365, 395)
Last edited by Phuocam; 12-05-2016 at 01:50 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks