Is there a macro code that will messagebox the cell that is in weekend.

[RiaMelissaJaravata]

Suppose I have the excel file in attached. How will it messagebox "Cells A3, A4, A10, A11, A17, A18, A24, A25, A31 and A32 are weekends"?
Is this possible? I hope you can help me. Thank you so much!

 

[Ronak Parekh]

this is not a macro but I hope the attached file would help!

I've used conditional formatting, text function and sumif funcation...

 

[Deepak]

this is not a macro but I hope the attached file would help!

I've used conditional formatting, text function and sumif funcation...

Hi Ronak Parekh,

What u did is nice but without using the helper column is already happen here.
This for your info only.

http://forum.chandoo.org/threads/is-there-a-macro-that-will-compute-values-for-weekends-only.23497

 

[Deepak]

Suppose I have the excel file in attached. How will it messagebox "Cells A3, A4, A10, A11, A17, A18, A24, A25, A31 and A32 are weekends"?
Is this possible? I hope you can help me. Thank you so much!

@RiaMelissaJaravata
Here's some clarity req.
1. how the macro will fire
2. what text would be on msgbox