Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell formula
I have a cell formula i want to modify so it says "YES" if today is a
monday and "No" if today is any other day of the week. =IF(B9="","YES","NO") at this stage it works if B9 is not empyy is this possible? thanks rslc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell formula
Hi,
How about this =IF(WEEKDAY(B9)=2,"Yes","No") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "rslc" wrote: I have a cell formula i want to modify so it says "YES" if today is a monday and "No" if today is any other day of the week. =IF(B9="","YES","NO") at this stage it works if B9 is not empyy is this possible? thanks rslc . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell formula
Try
=IF(WEEKDAY(B9)=2,"YES","NO") -- HTH Bob "rslc" wrote in message ... I have a cell formula i want to modify so it says "YES" if today is a monday and "No" if today is any other day of the week. =IF(B9="","YES","NO") at this stage it works if B9 is not empyy is this possible? thanks rslc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
Subtract cell formula from existing cell formula | Excel Programming | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |