Another question. What does the value in V4 represent? The number of bank
holidays that have passed in the year?

"Big Rick" wrote:

Hello Barb R.
In any one tax year (Apr to Mar.) there can be up to 10 Bank Holidays,
although this year, there are only 6. This is when I want to increment the
value of V4.
--
Big Rick


"Barb R." wrote:

Can you tell us when you want to increment the value in cell V4. That would
help.

"Big Rick" wrote:

Up to 10 times a year, I want to add a value of one to cell V4 starting with
zero.
I have come up with the following formula.
=IF(TODAY()<38530,(0),IF(TODAY()<38540,(1),IF(TODA Y()<38550,(2),IF(TODAY()<38560,(3),4)))) etc.
The problem is that I can only use the IF formula seven times.
I would very much appreciate it if you could write a new formula for me as I
am quite new to the whole thing and it took me weeks to work mine out!
(I have been advised to use the VLOOKUP formula but cannot get my head round
it.)
Thanking you in anticipation.
--
Big Rick