Help me with day and date formula

[imwitti]

Hey, i have 2 cells on a form of which one i had tomorrows day displayed eg today is monday and it shows Tuesday. i also have a cell which shows tomorrows date.

Problem is i want the first cell to show tomorrows day Except when tomorrows day is Saturday and then i want it to show "Sat-Mon"

2nd cell i want to show tomorrows date except when tomorrows date is a sat then i want it to show eg 9/4/11-11/4/11

is this possible?

Can someone help me with a formula if it is?

Thanks

Imwitti

 

[Osvaldo Palmeiro]

Hi.
Try:

=IF(WEEKDAY(TODAY()+1)=7,"Sat-Mon",TEXT(WEEKDAY(TODAY()+1),"dddd"))

=IF(WEEKDAY(TODAY()+1)=7,TEXT(TODAY()+1,"d/m/aa")&"-"&TEXT(TODAY()+3,"d/m/yy"),TODAY()+1)

 

[imwitti]

Brilliant this looks perfect thanks