tbarnard93
New Member
I have a table with two columns which shows the start and end date of an operation (Columns A & B of the attached). I'm looking for either a formula or VBA to get a daily profile which shows when the system is operational (See columns D & E for an example). Essentially where I have manually entered a 1 to represent the system as active or 0 to represent the system as inactive (column E), I want the formula/VBA to do this for me.