Macro to validate date & time period

[mishaq]

Hello,

I would like to have an excel macro where it should validate whether the results falls under a week day or a week end.

Let me elaborate it for better understanding. I have date(mm/dd/yyyy) & time (hh:mm) AM/PM in colum A & colum B. I want the macro to validate if the date & time in A1 is >= Friday 6:30 PM and the date & time in B1 is <= Monday 5:00 PM then C1 should reflect as weekend else weekday.

Basically if the date/time period between A1 & B1 falls between Friday 6:30 PM to Monday 5:00 PM then C1 should reflect weekend else weekday. And this validation should continue for all the cells A2 & B2, A3 & C3 and so on till the end of the colum until the cells are filled with date and time.

Any help is greatly appreciated. Thank you in advance.

Regards

[6StringJazzer]

This could be done with a formula. Do you require a macro instead of a formula?

[mishaq]

Hi Jeff

please provide the formula to get the appropriate results for now. however for a continuous use I would like to have a macro to do this job as I will be having around 25,000 to 30,000 rows to validate in this manner .

Thank you

[stnkynts]

Here is macro version:

Please Login or Register  to view this content.

[mishaq]

Hello

The above macro is based on only A colum however it should validate basing both A & B colums. If the time period falls under Friday 6:30 PM to Monday 5:00 PM then it should reflect Weekend else weekdays. Please check the attached sample.

Thank you

[sktneer]

Hello

The above macro is based on only A colum however it should validate basing both A & B colums. If the time period falls under Friday 6:30 PM to Monday 5:00 PM then it should reflect Weekend else weekdays. Please check the attached sample.

Thank you

See the attachment and test the macro and let me know if it works as per your requirement.