Forum Discussion
Recognise holidays
I have a spreadsheet with several sheets. Amongst these are sheets for the banks bills come out of which look at whether a day is the day a bill is due and return the amount due. I can get it to re...
Have you looked at the NetWorkDays function?
=NETWORKDAYS(start_date, end_date, [holidays])
'---
Nothing Left To Lose
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
(free excel programs)
=NETWORKDAYS(start_date, end_date, [holidays])
'---
Nothing Left To Lose
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
(free excel programs)
Nothing_Left_to_Lose I don't think that would work. My dates down side cover several months. They are currently running from now until end March 2023. (Due to tax year). The bills come out on the same day each month. Normally anything due on a weekend is paid on a Monday. If a payment becomes due on a bank holiday, it gets taken the next working day which can be upto 4 later e.g. the Tuesday after Good Friday. I don't think NETWORKDAYS allows for repeated occurrences on same day of each month or for variations in month lengths.