Hello, this is my first post and hopefully you all can help me out!
I am working on a project that has a column titled, "CalcBegDate" as well as "CalcEndDate". It is for a bank contract where we pay once a month for a swap transaction. I have already gone through and calculated the dates for a number of these swaps (For example, one swap may need to be paid on the first of every month. I have in the "CalcEndDate" column..."03/01/12...04/01/12....05/01/12...and so on"). Well, I was not reading the contracts well enough and forgot to account for the business days and holidays (Because not every 1st of the month will be during the week and not a holiday). I would like a formula that can calculate the correct "CalcEndDate" given I have already made each one the first of the month. So basically the formula will know if my date is correct, and if, not it will know to change it to the correct first business day of the month. I would like it to correct my mistake if possible because I have done a number of these incorrectly so I am looking for a formula that I can drag down to save me some time.
Basically I have the columns, "CalcBegDate" and "CalcEndDate" which are both incorrect. I am wondering if you could use an If function along with the workday function to check to see if some of may days happen to fall on the correct first business day of the month and if not, could change it to the correct date.
Any suggestions are welcome! Thank you in advance, I really appreciate it!
Andrew
Bookmarks