formula error text

[Joe@excel]

A1 shows the date format

A1 = date formated as dddd, mmmm dd, yyyy

on B1 i have formated as =A1 as "dddd" say for example that fo
12/4/2005 is a "sunday" per calendar.

in B7 i've set up a formula
=if(B1(day(B1)="Sunday",A1+3,if(B1(day(B1)="Wednesday",A1+4))

but this formula doesnt work B7 stays blank

what's wrong??? anybody please,,,, thank yo

 

[Dave Peterson]

=if(text(b1,"dddd")="sunday",....

But there's another function you may like--

=if(weekday(b1)=1,...

See Excel's help for =weekday() for more info.

 

[Dave Peterson]

And you could point directly to A1, too.

=if(text(b1,"dddd")="sunday",....

But there's another function you may like--

=if(weekday(b1)=1,...

See Excel's help for =weekday() for more info.

 

[Joe@excel]

Mr. Dave

Once again, you've save the day...

i however, have another request....

i have the following formula

=IF(TEXT(A6,"dddd")="Sunday",A6+3,IF(TEXT(A6,"dddd")="Wednesday",A6+4))


and it works fine. now, i need for it to stop once it hit the nex
month...

i want the above formula for a month at a time.... but sometimes i
goes beyond. say for example i'm working on December but it goes t
January...

A6:A16 has the above formula

A6 shows Sunday
A7 shows Wednesday
A8 shows Sunday
A9 shows Wednesday
A10 shows Sunday
A11 shows Wednesday

But i want it to stop once it reaches next month.

I tried
=IF(MONTH(A15)=MONTH(A6),IF(TEXT(A15,"dddd")="Sunday",A15+3,IF(TEXT(A15,"dddd")="Wednesday",A15+4)),"")

but it wont do.

 

[JE McGimpsey]

One way:

=IF(MONTH(A15)=MONTH(A$6),IF(WEEKDAY(A15)=1,A15+3,
IF(WEEKDAY(A15)=4,A15+4,"")),"")