Hello,
I have a formula in Column N that should populate a date if column L is yes, it will take column M and add 182 days.
THis is the formula I have: =IF(AND(L6="Yes",ISNUMBER(M6)),M6+182,"")
I'm thinking the 'ISNUMBER' should be something different?
I'd like to have it also that if column L does not say 'yes' or is blank that column N stays blank - so formula only populates for those lines that say "yes" in column L...
Is that possible?
Thank you so much!
I think your problem comes from the fact that your data in column M are not Date. And Excel can't even translate it to a date with a Datevalue function.
I tried putting a real date in a cell in column M and your formula works well.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
Hi,
My column M data comes from another giant database within the same workbook... the dates are updated frequently so the formula is there to make sure the information is up to date. Is there no way to add a date without getting rid of the formula in column M?
THanks again!
Actually column M is a formula that refer to an external workbook
You want to check this workbook and make sure the cells it refers to are really DATES.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks