View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Calculate holiday rate across holiday seasons

Hi Steve,

Am Wed, 18 Mar 2020 11:29:24 -0700 (PDT) schrieb Evets Snomis:

I have a tricky calculation I need to perform . . . I have the following data (this is a truncated version of it)

Season Start End Rate
--------------------------------------
Peak 1 01/01/2020 05/01/2020 1210
Peak 2 01/06/2020 31/08/2020 1210
Mid 01/09/2020 31/10/2020 1034
OffPeak 06/01/2020 31/05/2020 858


did you get my mail?


Regards
Claus B.
--
Windows10
Office 2016