 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2004first workday of a time period
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 -- Message posted from http://www.ExcelForum.com Hi try =WORKDAY(A1,1)  Signature-- Regards Frank Kabel Frankfurt, Germany > Hi > [quoted text clipped - 6 lines] > > So if today's date is 31/03/2004 the dates i need to generate based on > the current value of cell A1 would be. > [quoted text clipped - 4 lines] > > It has to be the first workday of the time period after the date in A1 > and not the first workday of for example this week which would be > 29/03/2004. [quoted text clipped - 10 lines] > --- > Message posted from http://www.ExcelForum.com/ 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()) SignatureKind Regards, Niek Otten Microsoft MVP - Excel > Hi > try [quoted text clipped - 39 lines] > > --- > > Message posted from http://www.ExcelForum.com/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.