Date setting and compare columns

**11ktran44** · 11-03-2011, 03:56 PM

Hello!
1. I have a "create date" cell A1 and cell A2 need to be 3 business days after create date (not counting weekends and holidays). I just don't knwo how to get this! Please help!
2. I have a worksheet MyLog that need to be updated every day. Every day I export a new report and I need to add new information from Column A, D, and column E from this report to MyLog Column A,D, and E. I have been pasting them by each collumn and manually comparing to add new lines for new information. Is there a way that I can compare and just extract what not in the Mylog so I can add them? Would someone be kind to teach me best way to do this please?

I am just intermediate with Excel and not a programmer. Your kind help is greatly appreciated.

Ktran

**alansidman** · 11-03-2011, 04:29 PM

First question. In A2, enter this formula

=IF(WEEKDAY(A1+3)=7,A1+5,IF(WEEKDAY(A1+3)=1,A1+4,A1+3))

If you have a list of holidays, then you will have to convert them to dates and add them to the if formula. You will need to update those each year. This could be cumbersome as an if function.