first workday of a time period

[ADE]

Hi

I need some help writing some formulas to produce the date of the firs
workday in four different time periods.

In cell A1 i have today's date =TODAY(),and the four formulas that
need to generate need to highlight the first workday of the time perio
after the date shown in A1.

So if today's date is 31/03/2004 the dates i need to generate based o
the current value of cell A1 would be.



WEEK 05/04/2004
MONTH 01/04/2004
YEAR 03/01/2005
DECADE 01/01/2010

It has to be the first workday of the time period after the date in A
and not the first workday of for example this week which would b
29/03/2004.
This would be incorrect as the answer i require would be 05/04/2004 fo
the weekly time frame.

Any holidays that fall as a weekday can be ignored as these ar
different in each country.


Many thanks

Ad

 

[Frank Kabel]

Hi
try
=WORKDAY(A1,1)

 

[Niek Otten]

That needs some fine-tuning, if I understand the OP well. Let's assume the
list with standard holidays (such as 1-1-2005) is in F1:F100.
The formula for a month could be could be

=WORKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()+1),0),0,F1:F100)

For a year:

=WORKDAY(DATE(YEAR(TODAY())+1,1,0),1,F1:F100)

Using the same techniques, you could establish the other dates (for first
day of week, use WEEKNUM() and WEEKDAY())


--

Kind Regards,

Niek Otten

Microsoft MVP - Excel