Formula Help, Please!

[AccentureTony]

Please help!

I want to make a formula (maybe an IF formula) that references anothe
cell's date to formulate a new date.

For example, I want cell U2 to have a date following the one I hav
inserted in cell T2 (if T2 is Monday 1/24/05 I want U2 to have Tuesda
1/25/05). But that's not the problem.

I want this:
If T2 is a wednesday, thursday, friday, saturday, or sunday (i.e
monday or tuesday ONLY), I want U2 to be the following monday instead
IS THERE AN IF FUNCTION FOR THIS? WHAT CAN I DO?

THANK YOU FOR YOUR HELP!!!!! I REALLY APPRECIATE IT!!!

 

[Frank Kabel]

Hi
try
=IF(WEEKDAY(T2,2)<=2,T2+1,T2+(8-WEEKDAY(T2,2))

 

[AccentureTony]

THANK YOU SO MUCH! It worked!

Thanks again, Frank! You were big time help and saved me hours!

 

[Daniel.M]

Another way:

I want this:
If T2 is a wednesday, thursday, friday, saturday, or sunday (i.e.
monday or tuesday ONLY), I want U2 to be the following monday instead.

=T2+MAX(2,7-WEEKDAY(T2-3))-1

Regards,

Daniel M.