Add £15 to a value out 7 days in a calendar month , every 7 days out add £15 to a value

**Smarty_Paris** · 10-09-2019, 11:11 AM

I need a formula which will add £15 out every 7th day of a calendar . Example Advance Purchase kicks in every 7 day and rate of the day reduces by £15.

Example : Column A in a full month ,day 1 to day 7 is same rate for selling a hotel room but on the day 8 the rate changes to less £15 in column B .
So Flexible rate is in Column A and Advance purchase rate from 7th Day is less than £15
what formula can i use to automate below

01-Oct £100 £100
02-Oct £100 £100
03-Oct £100 £100
04-Oct £100 £100
05-Oct £100 £100
06-Oct £100 £100
07-Oct £100 £100
08-Oct £100 £85
09-Oct £100 £85
10-Oct £100 £85
11-Oct £100 £85
12-Oct £100 £85
13-Oct £100 £85
14-Oct £100 £85
15-Oct £100 £85
16-Oct £100 £85
17-Oct £100 £85

**maras_mak** · 10-09-2019, 11:40 AM

Use the formula below

HTML Code:

**Smarty_Paris** · 10-09-2019, 12:16 PM

Dear Maras, you are very kind . please see below , their are 2 rates in 2 different column , all i need is to show on 7th Day the rate -£15 of the said value , example
Day 15th I want the Column A to automatically reduce Column B by £15 and continue to do so but only from 8th Day not for the first 7 days .
So the Hotel shows for the first 7 days same rate on both column and only from 8th Day Column A is less by £15 from Column B and it continues for end of the month or future . I appreciate your help
08-10-19 135 135
09-10-19 235 235
10-10-19 99 99
11-10-19 90 90
12-10-19 159 159
13-10-19 70 70
14-10-19 110 110
15-10-19 120 220
16-10-19 220 X
17-10-19 84 95
18-10-19 60 95
19-10-19 129 125
20-10-19 40 70
21-10-19 80 105
22-10-19 190 130

**maras_mak** · 10-09-2019, 12:28 PM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need.
Make sure your desired results are shown.

**Smarty_Paris** · 10-09-2019, 01:04 PM

Date "TFR
The Flexible Rate " "
The Best less £15 out 7 Day"

09-10-19 150 150
10-10-19 160 160
11-10-19 168 168
12-10-19 156 156
13-10-19 159 159
14-10-19 157 157
15-10-19 180 180
16-10-19 170 165
17-10-19 160 145
18-10-19 134 119
19-10-19 167 152
20-10-19 145 130
21-10-19 170 155
22-10-19 175 160
23-10-19 179 164
24-10-19 120 105

**Smarty_Paris** · 10-09-2019, 01:06 PM

I have attached a sample what i want from 8th Day , basically for first 7 days both rates remain same but best rate is reduced by £15 from 8th day
so what formula can I use to automate it .
thanks

**maras_mak** · 10-09-2019, 01:18 PM

C4 formula and drag down.

HTML Code:

Add £15 to a value out 7 days in a calendar month , every 7 days out add £15 to a value

LinkBack

Thread Tools

Rate This Thread

Display

Add £15 to a value out 7 days in a calendar month , every 7 days out add £15 to a value

Re: Add £15 to a value out 7 days in a calendar month , every 7 days out add £15 to a val

Re: Add £15 to a value out 7 days in a calendar month , every 7 days out add £15 to a val

Re: Add £15 to a value out 7 days in a calendar month , every 7 days out add £15 to a val

Re: Add £15 to a value out 7 days in a calendar month , every 7 days out add £15 to a val

Re: Add £15 to a value out 7 days in a calendar month , every 7 days out add £15 to a val

Re: Add £15 to a value out 7 days in a calendar month , every 7 days out add £15 to a val

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Splitting days in a week over a calendar month

[SOLVED] Formula to calculate working days and calendar days per month-year ?

Disable past days and give days a colour in a Calendar

[SOLVED] Count the number of days in the year to date less the days in the current month

First & Last Business Days of Month with Public Holidays and Non-work days

[SOLVED] Calendar Formula- Date given/add 90 days/ defult - 1st day next month

Generating business days in a calendar month, EXCLUDING holidays

Bookmarks

Bookmarks

Posting Permissions