Find a Day in a Calendar

S

Steved

Hello from Steved

The below formula will find the last day off each month

My question is please What Formula would I use to find a individual day, for
example 6th off June

=MONTH(A1)<>MONTH(A1+1)

Thankyou.
 
R

Rick Rothstein \(MVP - VB\)

Actually, your formula doesn't "find" the last day of each month, it just
returns True if the date in A1 is the last day of the month. Is that the
test you want to perform for the 6th day of the month? If so, this
formula...

=DAY(A1)=6

will return True if the date in A1 is the 6th of the month (without testing
which month that is). If you need to test specifically for the 6th of June,
then this formula would do that....

=AND(Month(A1)=6,DAY(A1)=6)

where you put the month and day numbers in the obvious places.

Rick
 
S

Steved

Hello Rick from Steved

{=IF(MONTH(D3-DAY(D3)+1-WEEKDAY(D3-DAY(D3)+1)+Mtx)=MONTH(D3),D3-DAY(D3)+1-WEEKDAY(D3-DAY(D3)+1)+Mtx,"")}

The above is how I've contrasted my twelve month calendar to get the days and
DATE(YEAR(AB3),MONTH(AB3)+1,DAY(AB3)) for the months this example is June.

Using =MONTH(A1)<>MONTH(A1+1) in conditional formating it has as you know
allowed me to format the last day off each month. ( "Red Font ,Yellow Fill" )

=AND(Month(A1)=6,DAY(A1)=6) it can not find what would I need to do to my
formulas for the Month to get your formula to work please.
 
S

Steved

Hello from Steved

It took me a while to figure out if I put in the Cell range it works

Thankyou.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top