Forum Discussion

110dbmichael's avatar
110dbmichael
Copper Contributor
Jan 22, 2022
Solved

Dynamic Pricing (increase or discount on prices based on Month/Day)

Did a good bit of searching before posting and cant seem to find anything; I have a special event business that is seasonal with high demand on weekends and trying to improve our way of charging for ...
  • compassguy's avatar
    Jan 22, 2022

    110dbmichael 

     

    Here's another way to do what Hans has suggested:

    https://docs.google.com/spreadsheets/d/1O_mBs7R3bzziZ0AbJ-4hofWohlOee87G5ciArGwfdWY/edit?usp=sharing

    You may be able to understand the logic a little more easily.

    Cells B7 and B8 have been equipped with Data Validation to help prevent entry spelling errors.

     

    David