Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home

Date formula based on =today()?

Posted by Lori on December 05, 2001 10:04 AM
Is there a formula that will return the next workingday (the date) based on the formula =today()?
Thanks to anyone who can help me!

=WORKDAY(TODAY(),1) should work.

Posted by Aladin Akyurek on December 05, 2001 10:11 AM


Re: Date formula based on =today()? "+ 1"(NT)

Posted by Oliver on December 05, 2001 10:12 AM


Re: Date formula based on =today()?

Posted by IML on December 05, 2001 10:38 AM

You could also use
=(NOW()+1)+(WEEKDAY(NOW())=6)*2+(WEEKDAY(NOW())=7)

What you would gain over =Workday function would the need for you (and others) to install the analysis toolpak.

What you would lose versus the Workday function is the ability to exclude holidays.

Good luck


One more question on this?

Posted by Lori on December 05, 2001 11:32 AM

Thanks all- for the answers. One more question...I am trying to concatene 2 cells, this is one of them. The result I'm getting for the date part is not formatted correctly. Excel is returning a number instead of the date.



Use =A1 & TEXT(A2,"dd-mm-yyyy") where A2 is the cell with the date (NT)

Posted by Juan Pablo G. on December 05, 2001 11:36 AM



Thanks. Working great!

Posted by Lori on December 05, 2001 12:46 PM


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.