#### jhoncena33

##### New Member

Greetings everyone,

I want to calculate P and OD in the given Excel. I also want to calculate holidays only if they fall between either P or OD at both ends. If there is VL at either end, then I do not want to calculate holidays. Please keep in mind that there may be more than one holiday back to back. i want to solve this problem only with formula.

example 01

total days 03

example 02

total days 01

thanks

I want to calculate P and OD in the given Excel. I also want to calculate holidays only if they fall between either P or OD at both ends. If there is VL at either end, then I do not want to calculate holidays. Please keep in mind that there may be more than one holiday back to back. i want to solve this problem only with formula.

example 01

20-05-2023 | P |

21-05-2023 | Holiday |

22-05-2023 | OD |

total days 03

example 02

25-05-2023 | VL |

26-05-2023 | VL |

27-05-2023 | Holiday |

28-05-2023 | Holiday |

29-05-2023 | P |

total days 01

thanks