Formula to minus 1 day based upon content of another cell

[missydanni]

Am sure it's fairly simple to do and I am fairly certain I have done this before I just cant find the SS I did it in!

I would like a formula where dependent on the number in 1 cell, 1 day is minused from the date.

I.e. if the contents of cell A1 is less than 7, then take 1 day from the date in cell B1, otherwise give me the date in cell B1

I thought I had got it using an IF statement, but it is doing something weird and adding a year on.

Thanks in advance

[Glenn Kennedy]

Try this:

=IF(A1<7,B1-1,B1)

[Tony Valko]

One way...

=B1-(A1<7)

Format as Date

[missydanni]

Thanks for the assitance!

Have sorted it now, I had done it the way Glen suggested but for some reason it hadn't worked, retyped as per above and it now works!

In my humble opinion, Excel is really weird somtimes