If Functions

[RedOctoberKnight]

Hello,

I'm sure this will be pretty easy for somebody out there.

I'm looking to formulate a cell based on two variables.

The first variable would be the current date, If the day of the month is odd, then mark an X in column A. If it's even, leave column A blank.

The 2nd variable would be if there is an "X" in column B, then the "X" in column A would disappear (or become blank)

For example,

if todays date is 10/23 then it would populate an "X" in column A, but if I manually input an "X" in column B, then the X in Column A would disappear (or become blank).

Any help would be much appreciated.

 

[Joe4]

Try this (for row 1):

=IF(OR(ISEVEN(DAY(TODAY())),B1="X"),"","X")

 

[RedOctoberKnight]

Awesome! Thank you!

How would I do it if i wanted the same scenario above but instead of odd days, it would mark an "X" in column A for even days?

 

[Joe4]

How would I do it if i wanted the same scenario above but instead of odd days, it would mark an "X" in column A for even days?

Use the ISODD function instead of the ISEVEN function.