| 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! |
| 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 | |||
Threaded Mode
