Auto Calculate weekday, weekend, and Holiday formula needed

[trankim]

Is there a formula that I can add to either my existing formula or create a new one that will return if that date was a fixed holiday?

Here's what I used to create whether that date was a weekend or a M - F, but I would also like for it recognize if it's a holiday.

IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7),"Weekend","M-F")

Thank you so much!

 

[T. Valko]

Is there a formula that I can add to either my existing formula or create a new one that will return if that date was a fixed holiday?

Here's what I used to create whether that date was a weekend or a M - F, but I would also like for it recognize if it's a holiday.

IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7),"Weekend","M-F")

Thank you so much!

You can try something like this.

Assuming you have a list of holiday dates in B1:B10.

A1 = some date

=IF(COUNTIF(B1:B10,A1),"Holiday",IF(WEEKDAY(A1,2)<6,"Weekday","Weekend"))

 

[trankim]

Thanks, I'll try that!

 

[trankim]

I was wondering if there was a way that we can write a formula that does not need to refer to a list of holidays....is there a "holiday" formula that knows the fixed dates that are like christmas, new years, thanksgiving, labor day, etc and just automatically calculates that as a holiday? Just curious if this is possible

thanks!

 

[T. Valko]

I was wondering if there was a way that we can write a formula that does not need to refer to a list of holidays....is there a "holiday" formula that knows the fixed dates that are like christmas, new years, thanksgiving, labor day, etc and just automatically calculates that as a holiday? Just curious if this is possible

thanks!

Excel doesn't know a date is a holiday unless you tell it so.

You can put the holiday dates directly into the formula instead of listing them in a range of cells but if you have many then the formula will be really long.

 

[trankim]

That makes Total sense! thanks again!

 

[T. Valko]

That makes Total sense! thanks again!

You're welcome. Thanks for the feedback!