# 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.