Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement evaluating Dates and Weekdays
I have the date in cell B7 (shows 1 for 1 Sept 08). In cell B6 I have the
corresponding day of the week (formula in B6 is =B7, formatted to show ddd). B C D 6 Mon Tue Wed 7 1 2 3 8 450 450 450 In cell B8, I want to input a formula to evaluate B6. If B6 equals Saturday or Sunday, then return " ", otherwise return 7.5*60. Can anyone help me with this? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement evaluating Dates and Weekdays
=IF(OR(B6="Sat",B6="Sun")," ",7.5*60)
Copy across the row. "jwfullerton" wrote: I have the date in cell B7 (shows 1 for 1 Sept 08). In cell B6 I have the corresponding day of the week (formula in B6 is =B7, formatted to show ddd). B C D 6 Mon Tue Wed 7 1 2 3 8 450 450 450 In cell B8, I want to input a formula to evaluate B6. If B6 equals Saturday or Sunday, then return " ", otherwise return 7.5*60. Can anyone help me with this? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement evaluating Dates and Weekdays
Sean,
Thanks for the formula. It is returning the FALSE response (7.5*60) even on the days when the cells are Saturday or Sunday. Any suggestions? "Sean Timmons" wrote: =IF(OR(B6="Sat",B6="Sun")," ",7.5*60) Copy across the row. "jwfullerton" wrote: I have the date in cell B7 (shows 1 for 1 Sept 08). In cell B6 I have the corresponding day of the week (formula in B6 is =B7, formatted to show ddd). B C D 6 Mon Tue Wed 7 1 2 3 8 450 450 450 In cell B8, I want to input a formula to evaluate B6. If B6 equals Saturday or Sunday, then return " ", otherwise return 7.5*60. Can anyone help me with this? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement evaluating Dates and Weekdays
=IF(LEFT(TEXT(B6,"ddd"),1)="S"," ",7.5*60) and fill right.
"Sean Timmons" wrote in message ... =IF(OR(B6="Sat",B6="Sun")," ",7.5*60) Copy across the row. "jwfullerton" wrote: I have the date in cell B7 (shows 1 for 1 Sept 08). In cell B6 I have the corresponding day of the week (formula in B6 is =B7, formatted to show ddd). B C D 6 Mon Tue Wed 7 1 2 3 8 450 450 450 In cell B8, I want to input a formula to evaluate B6. If B6 equals Saturday or Sunday, then return " ", otherwise return 7.5*60. Can anyone help me with this? Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement evaluating Dates and Weekdays
Perfect, thank you both for your help!
"Bob Umlas" wrote: =IF(LEFT(TEXT(B6,"ddd"),1)="S"," ",7.5*60) and fill right. "Sean Timmons" wrote in message ... =IF(OR(B6="Sat",B6="Sun")," ",7.5*60) Copy across the row. "jwfullerton" wrote: I have the date in cell B7 (shows 1 for 1 Sept 08). In cell B6 I have the corresponding day of the week (formula in B6 is =B7, formatted to show ddd). B C D 6 Mon Tue Wed 7 1 2 3 8 450 450 450 In cell B8, I want to input a formula to evaluate B6. If B6 equals Saturday or Sunday, then return " ", otherwise return 7.5*60. Can anyone help me with this? Thanks! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement evaluating Dates and Weekdays
Are the values in Row 7 dates? If not I would make them dates. Enter
1/9/08 in B7 and drag across on the fill handle to fill in all dates in September. Then format the cells as "d" (without the quotes) to give the nunbers. Next enter =B7 in cell B6 and format as "ddd" (again without the quotes), and drag along on the fill handle to give the day names. In B8 I would then use the formula: =IF(WEEKDAY(B7,2)5,"",7.5*60) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "jwfullerton" wrote in message ... I have the date in cell B7 (shows 1 for 1 Sept 08). In cell B6 I have the corresponding day of the week (formula in B6 is =B7, formatted to show ddd). B C D 6 Mon Tue Wed 7 1 2 3 8 450 450 450 In cell B8, I want to input a formula to evaluate B6. If B6 equals Saturday or Sunday, then return " ", otherwise return 7.5*60. Can anyone help me with this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round dates to weekdays | Excel Worksheet Functions | |||
Difference (weekdays) between two dates | Excel Worksheet Functions | |||
dates for weekdays in non-contiguous cells | Excel Worksheet Functions | |||
IF statement with Weekends vs. weekdays | Excel Worksheet Functions | |||
How do i count number of weekdays between two dates? | Excel Worksheet Functions |