Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date and time questions
i tried to install an addin because i cant get the
workday function to work - but it wont let me? Also any advice on how to do this?? I need to be able to punch in a date at the top of a column - and then for the remainder of the spreadsheet I need excel to show me the rest of the workdays for the next 65 days. Also how do I get excel to calculate the difference between two entered dates. Thanks for your help Jake Ballard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
date and time questions
Row 1, input the date
Row 2: =WORKDAY($A$1,ROW()-1) and copy down If you just want the number of days between 2 dates, just subtract them,. If you want the number of working days use NETWORKDAYS -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Jake Ballard" wrote in message ... i tried to install an addin because i cant get the workday function to work - but it wont let me? Also any advice on how to do this?? I need to be able to punch in a date at the top of a column - and then for the remainder of the spreadsheet I need excel to show me the rest of the workdays for the next 65 days. Also how do I get excel to calculate the difference between two entered dates. Thanks for your help Jake Ballard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Calculation and formulas needed (2 questions) | Excel Worksheet Functions | |||
2 questions! Related to combobox and time function. HELP!! | Excel Discussion (Misc queries) | |||
time questions (roundup & convert hh to mm | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
More time questions and IF function problem | Excel Worksheet Functions |