Formulas for Dates problem

[Francis85]

Hi,

I'm working on a spread sheet that I'm getting stumped on.

In cell B2 I have the formula =Today() (which as I'm sure you know, picks up the current days date). The format is DD/MM/YYYY.

If this date is between 01/MM/YYYY and 08/MM/YYYY then I want it to display 6.25
If this date is between 09/MM/YYYY and 15/MM/YYYY then I want it to display 6.5
If this date is between 16/MM/YYYY and 22/MM/YYYY then I want it to display 6.75
If this date is between 23/MM/YYYY and 31/MM/YYYY then I want it to display 7

I'm having trouble writing the whole formula as I've never worked with dates and 'IF' statements before.

Many thanks in advance for your help.

 

[Jonmo1]

Welcome to the board.

Try

=LOOKUP(DAY(B2),{1,9,16,23},{6.25,6.5,6.75,7})

 

[Francis85]

Many thanks!

I've just been playing around with different formulas. I tried this one instead;

B2 =Today() returns 26/02/2014
C2 =day(B2) returns 26
D2 =(C2/30)+6 returns 6.867

I'm trying to break the month up to get an average for ordering stock, this does it a bit more precise than my original way of thinking. Although, just tried your method and works well too.

Thanks again