display X or / for specific days

  • Thread starter Thread starter jakol
  • Start date Start date
J

jakol

is there a formula to display an x or / for specific days in a cell.
like every monday, weds, and friday only i would like to display the x
or maybe slash in the cell. thank you much.
 
Hi
you may use the following in B1 if A1 stores a date
=IF(OR(WEEKDAY(A1,1)=2,WEEKDAY(A1,1)=4,WEEKDAY(A1,1)=6),"X","")
 
hii frank
thanks for the reply tried it but its not working, does not displa
anything. am i doing something wrong? tried the above formula for 1
consecutive cells but no X, the formula seems to be valid though
 
hii frank
thanks for the reply tried it but its not working, does not displa
anything. am i doing something wrong? tried the above formula for 1
consecutive cells but no X, the formula seems to be valid though
 
Hi Jakol!

Not:
=IF(MOD(WEEKDAY(A1),1)=0,"X","")

You need:
=IF(MOD(WEEKDAY(A1),2)=0,"X","")

I get both Frank's formula and the above to return a blank if my date
is text. So I suspect that your dates are not dates.

You can test using =ISTEXT(A1) if that returns TRUE then that is your
problem.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
you guys are right my date is text, another problem is every cell
entered the above formula it displays X, i intended to mark x ever
mon,weds,friday for 30-31 consecutive cell representing days of th
month, how do u do these? sorry for not clarifying these in the firs
place. thank you much for ur help
 
nevermind guys, i figure it out using above formulas with som
modifications, thank you all...thanks .;)

anyway, i dont know if i have to open a new thread for this one, jus
one more question, i have created a sheet basically like a database s
other sheets with same formulas can be pointed/ referred to this sheet
but the other sheets does not recalculate unless i open my databas
sheet, even with automatic recalculation selected under option, is i
supposed to be like this? thank you again
 
Start a new post with an appropriate subject line and be sure to include
examples of the formulas you say are not working.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

nevermind guys, i figure it out using above formulas with some
modifications, thank you all...thanks .;)

anyway, i dont know if i have to open a new thread for this one, just
one more question, i have created a sheet basically like a database so
other sheets with same formulas can be pointed/ referred to this sheet,
but the other sheets does not recalculate unless i open my database
sheet, even with automatic recalculation selected under option, is it
supposed to be like this? thank you again.
 
Back
Top