Using Date Today and Date Needed please help.

[Raist]

I used =today() formula but I need another cell that the date must be tomorrow.

Example:

A1= Date Printed

B1=today() B1= Wednesday, October 10, 2012

C1 = Date Needed ( Date needed here must be tommorrow)

D1= Thursday, October 11, 2012

if it is a Saturday then

B1= Saturday, October 13, 2012

then D1= Monday, October 15, 2012.

What formula should I use ?

[FDibbins]

for c1, use =today()+1

for D1, to skip weekends, try this

=IF(WEEKDAY(TODAY()+1,2)>7,TODAY()+3,TODAY()+1)

its not weekend, so you may have to play with the +'s to make sure its working right

[alansidman]

c1 = today()+1

D1 = if(weekday(today())=7,today()+2,today()+1)

[Teethless mama]

C1: =today()+1

d1: =workday(today(),1)

[Raist]

Thanks for the replies, can I put the two formulas only in one cell B1?

Example:

A1=today() this will show the date today.
B1= "Date tomorrow" if it is saturday today then it will put monday automatically?

[Raist]

Thanks to everyone. Problem solved. Thread closed.