ST Alpha - "Excel help needed" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 151

Excel help needed

Posted by con_carne Jan 13 '10, 13:55

The function WORKDAY needs a start date to be plugged in. Is there a way to just tell it to use today's date? Whatever date that may be?

Responses:

spoiler? - marcel Jan 13, 14:06
create a new cell with the value "=TODAY()", and have the WORKDAY function reference that cell at the starting date -- nm - znufrii Jan 13, 13:58
Now() -- nm - JaxSean Jan 13, 13:57 1
- "=workday(now(), 10)" will return 1/27/2010, or 10 workdays from today. -- nm - JaxSean Jan 13, 13:59

Post a message top

Replies are disabled on threads older than 7 days.