Due Date

[Ash3154]

Hi

I need to set up a due date;
the due date is a weekday on the last day of the current month, if its a weekend (Sat, Sun, or Holiday), it will due the next weekday of the next month.

I don't want to use a macro, is there any way to do this using formula?

Thanks,
Ash

 

[Misca]

Try:

=WORKDAY(DATE(YEAR(StartDate),MONTH(StartDate)+1,-1),1,Holidays)

Where StartDate is the date (if it's always current month you're interested you can replace the StartDate with TODAY()-function ) and Holidays is a range where all the holidays can be found.

If you're using Excel 2003 you need to make sure you have the Analysis Toolpak installed.

 

[Ash3154]

That done the trick, thanks so much.