Search results

Thanks Hui and Haseeb for the help. The formulas worked as requested. However, for a learner like me could you explain to me what the number 14 does in the formula ? Is it subtracting F1 day from A16 day date ? I assumed by manipulating that number (14) to say 5,10 etc. I get the condition to...

Hello Folks, I am trying my luck once more for a solution to my vexed problem by continuing on my earlier postings. I have tired all sorts of things but nothing seems working. Attached here with is the link for the test worksheet "PENDING-TEST3.XLMS "...

Hui, Thanks a lot for the formula. Works like a charm FOR THAT PARTICULAR DAY 15 FOR ANY MONTH / YEAR. However problem is before or after that day. For e.g. as the date today is May 17 its showing "bad date". So whats a way to work around that and keep the original current month data till the...

Hello Hui, I want the data in Fields E4 and K4 in the excel file get automatically updated 15th of EVERY month ( when both the values of F1 and corresponding value of A17-A30 match ) with the corresponding values of "EMI" and "Outstanding" in the table (A17 -C 30) below in the Test excel...

Hi Faseeh, I looked at the link you had send me but that is not what I wanted. In the meantime I have followed your instructions and uploaded the file in Google Docs. Here is the link for it. https://docs.google.com/open?id=0B4X1gMMzKVU9OFppcnh6RExMbFk I hope you are able to understand...

Hello Everyone, Sorry for cross posting this somewhere else with no malice intentions. I have a question on making a formula with real time date function. I have built my own simple personal money management worksheet. I want to know how I can write a formula which can automatically change 1...

Hi Montrey, OPPS ! Sorry. That was not my intention at all. My Apologies to anyone affected by my unintended actions. Will do as you recommended. RM

Hello Sir, I have a question on making a formula. I have built my own simple personal money management worksheet. I want to know how I can write a formula which can automatically deduct mortgage amount from my income every month by the 15th for the next 5 years. I have this data for the...