Posted by Thomas on October 26, 2001 10:49 AM
I have a problem to write down a formula of counting dates.
Suppose I want the date of 16 days later locates on a business day.I write down the formula A1+16 in a cell. How do I develop the formula lacates on a business day.
Here is an example:
if today is 10/25/01,16 days later would be locates on the Saturday,but I want the result locates on the first following business day, which is 11/10/01. Today is 10/26/01,16 days later would be locates on Sunday,but I want the result shows the following business day,which is 11/10/01. Same as the previous one. Of course, there are some holidays issue need to be considered. Is there any add-in functions I can use in Excel? OR How do I develop a formula for that?Or should I write down a Macro for this?
Thanks for thrift respond.