ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   dAY wORK wEEK (https://www.excelbanter.com/excel-discussion-misc-queries/200550-day-work-week.html)

MÃRIO MLMEIDA

dAY wORK wEEK
 
I EVERYONE.SORRY MY ENGLISH.

I WANT TO NOW, WHO CAN GET IN EXCEL 2003 THE FORMULA, TO ALLOW INPUT THE
DIFFERENCE BETWEEN TWO DATES, AT THE DAY WORK WEEK AND NOT WEEKEND!!!I TRY,
BUT MY EXCEL DONT HAVE THIS OPTION.

THANK YOU. pLEASE ANSWER FOR MY E-MAIL.


Bob Phillips

dAY wORK wEEK
 
Go To ToolsAddins and check Analysis Toolpak.

Then use

=WORKDAY(A1,A2)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MÁRIO MLMEIDA" <MÁRIO wrote in message
...
I EVERYONE.SORRY MY ENGLISH.

I WANT TO NOW, WHO CAN GET IN EXCEL 2003 THE FORMULA, TO ALLOW INPUT THE
DIFFERENCE BETWEEN TWO DATES, AT THE DAY WORK WEEK AND NOT WEEKEND!!!I
TRY,
BUT MY EXCEL DONT HAVE THIS OPTION.

THANK YOU. pLEASE ANSWER FOR MY E-MAIL.





All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com