IF Command conditional formating

[IDCrewDawg]

I am creating a interactive calander for appointment scheduling.

The last three days of the month vary depending on month, I have used
combination of two date commands to forcast the next month. I use th
=TODAY() command to get the current month, then use th
=DATE(YEAR(cell),MONTH(cell)+1,1) refence the TODAY command to forcas
the next month.

What I want, is to make the 29th, 30th & 31st conditionally formated.
know I know how to do conditional formating for the cell givin a certia
value, but I don't know how to bring data from outside the cell to mee
the formating I want.

For instance, I would like to have an IF command that gives the valu
of 29 for the months that contain the 29th day, and like wise for th
other days of other months.

Once I know how to retrieve the data I want, I already know how t
format the cell.

The help is greatly appreciated

 

[Bernie Deitrick]

IDCrewDawg,

If cell has a valid date

For the conditional formatting use:
=MONTH($column of cell$row of cell)=MONTH(currentCell)

For the IF formula, use
=IF(MONTH($cell$)=MONTH(cell above currentCell +1),cell above currentCell +1,"")

formatted as dd.

HTH,
Bernie
MS Excel MVP

 

[IDCrewDawg]

Ok, thats just a tad confusing. Pretend I don't know much about excel,
cause I don't.

So here is what I have.

I use the =TODAY() command in cell B25 to get the current month. Then I
use =DATE(YEAR(B25),MONTH(B25)+1,1) to give me the next comming month,
in this instance it appears as October.

This appears in cell B34. Now the day of the month 29 appears in cell
O35. So what I would like is to reference cell B34 to make the value 29
appear in cell O35 when months containing 29 days come up. The month 02
is the only one that doesnt, so a false command could be used
referencing the 2nd month. But I don't know how to do that. Conversly,
if I have a month that has only 30 days, I would use a true command,
for the months Apr Jun and Sep, to make the value 30 come up, and then
something like that again for 31 for those months that have 31.

I just don't know how to do the true false command referenceing a
different cell, resulting in a given value.

If thats too confusing let me know. I will try and elaborate.

Help is appreciated

 

[Bernie Deitrick]

IDCrewDawg,

How about this? In O35, enter the formula

=IF(MONTH(DATE(YEAR($B$25),MONTH($B$25)+1,ROW()-6))=MONTH($B$34),DATE(YEAR($B$25),MONTH($B$25)+1,ROW()-6),"")

all on one row (your newsreader may wrap the text)
and copy to O7:O37 (I'm assuming your month's dates are all in a column)

HTH,
Bernie
MS Excel MVP

 

[IDCrewDawg]

Bernie, thanks for all the help! My cells are in a row rather than a
colum. I want to put this information into cell 035 P35 Q35. If you
give me your email address I could mail it to you, so you can see what
I am trying to do.

 

[Bernie Deitrick]

IDCrewDawg,

Reply to this message, and take the spaces out of my email address, and change the dot to .

HTH,
Bernie
MS Excel MVP

 

[IDCrewDawg]

Bernie,

I don't see anything that looks like your email adress.

Mine is

randall dot rogers at spangdahlem dot af dot mil

of course you will have to replace the dot with . and remove th
spaces.

 

[Bernie Deitrick]

Check your inbox.....

HTH,
Bernie
MS Excel MVP

Bernie,

I don't see anything that looks like your email adress.

Mine is

randall dot rogers at spangdahlem dot af dot mil

of course you will have to replace the dot with . and remove the
spaces.