date and time questions

J

Jake Ballard

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
 
B

Bob Phillips

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)
 
Top