meganisagee
New Member
- Joined
- Nov 30, 2022
- Messages
- 13
- Office Version
- 2016
- Platform
- Windows
Hi everyone,
I currently have a formula which identifies when an application date is on a weekend and when it is on a holiday. When it's a weekend, it says "Application date is a weekend." When it's a holiday, it says "Application date is a holiday." However, if the date happens to be a weekend AND a holiday (such as 1/1/2023), both conditions are met and it displays "Note: Application date is a weekend.Note: Application date is a holiday."
I'd like to combine the formulas so if the application is on a weekend, holiday, or happens to be on both, the text will display "Note: Application date is a weekend/holiday."
Here's what I have (note the beginning is if the field is blank, it doesn't show anything):
Thanks in advance.
I currently have a formula which identifies when an application date is on a weekend and when it is on a holiday. When it's a weekend, it says "Application date is a weekend." When it's a holiday, it says "Application date is a holiday." However, if the date happens to be a weekend AND a holiday (such as 1/1/2023), both conditions are met and it displays "Note: Application date is a weekend.Note: Application date is a holiday."
I'd like to combine the formulas so if the application is on a weekend, holiday, or happens to be on both, the text will display "Note: Application date is a weekend/holiday."
Here's what I have (note the beginning is if the field is blank, it doesn't show anything):
Thanks in advance.