calculating the next working day

[ADE]

Hi

Hopefully somebody can help me please.

If i have the =TODAY() formula in cell A1 and i want cell A2 to sho
the date of the next working day after the date shown in A1,how would
write this formula.


I am also using the =TEXT(A1"DDDD") formula to show the correspondin
day in words.This only gives the day in lower case and i would prefe
it to appear in upper case,how would i convert it.


A thousand thanks for your help

Ad

 

[Dave Hawley]

Hi Ade

For Q 1 try

=WORKDAY(EOMONTH(A1,0),0,Holidays)

Both these function require you to go to Tools>add-ins and check
"Analysis Toolpak"

For number 2 use
=UPPER(TEXT(A1"DDDD"))


***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Dave Hawley]

Should mention that "Holidays" is a named range consisting of holiday
dates.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Dave Hawley]

Problem solved. See:
http://www.ozgrid.com/forum/viewthread.php?tid=10059

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****