andrewvanmarle
New Member
- Joined
- Aug 11, 2015
- Messages
- 40
Hi All,
I have a list of national holdays and the current year in A1
This is the formula for the date:
And it works, but......
We wouldnt be dutch if we didnt make things complicated:
This is only a holiday every fith year.
So i'm looking for something that goes IF a1 is divisible by 5 then show the above date else NULL
What would that formula look like?
I have a list of national holdays and the current year in A1
This is the formula for the date:
Excel Formula:
=DATUM(A1;5;5)
And it works, but......
We wouldnt be dutch if we didnt make things complicated:
This is only a holiday every fith year.
So i'm looking for something that goes IF a1 is divisible by 5 then show the above date else NULL
What would that formula look like?