Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Hi, I have a single cell named range into which, goes an integer representing a number of weekdays. This number is subtracted from a column of dates (Data Validation prevents entry of a weekend date in this column) to hopefully produce another weekday in another column. Something like: old weekday date - named range integer =new weekday date I would like to avoid the Workday function simply because I share this file with different people that are constantly changing and it is a pain to attach instructions for installing the Analysis Tool Pak. Anyone have a brilliant solution? Many thanks in advance. -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=397219 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
Number of days since a date | New Users to Excel | |||
How to Add 5 working days | Excel Discussion (Misc queries) | |||
How can I subtract 111 from a number like 097 and get 987, using . | Excel Worksheet Functions | |||
Date Difference On Working Days | Excel Worksheet Functions |