happy_smiler1
New member
- Joined
- Aug 28, 2012
- Messages
- 67
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- office 365
Hi All,
In my spreadsheet attached, I have a gift date, based against the UK bank holiday date, I wanted to check if the gift date lands on the bank holiday date, if it does, then in date gift received would then add 2 days to the gift date, if it doesnt then it would just display the gift date. I would need this for every bank holiday in the uk, however as a starting point it would be helpful if anyone could give me some guidance.
TIA
In my spreadsheet attached, I have a gift date, based against the UK bank holiday date, I wanted to check if the gift date lands on the bank holiday date, if it does, then in date gift received would then add 2 days to the gift date, if it doesnt then it would just display the gift date. I would need this for every bank holiday in the uk, however as a starting point it would be helpful if anyone could give me some guidance.
TIA