Below is an excel formula i created that will result in either of the following:
Weekend, Week Night, or Week Day
If Saturday or Sunday shows in column AL my result is 'Weekend'. If result falls on a Week day (Monday-Friday) between hours of 12a-7:59p the result will be 'Week Day'; and 'Week Night' as my false value.
Below is my fomula:
=IF(OR(AL2="Saturday",AL2="Sunday"),"Weekend",IF(AND(AL2="Monday",AL2="Tuesday",AL2="Wednesday",AL2="Thursday",AL2="Friday",D2>TIME(12,0,0),D2
The Weekend part of the formula works; but all my others result in Week Night
Please help!
Aucun commentaire:
Enregistrer un commentaire