weekly addition

[dree]

Hi,

I'm completely new to excel and I'm still trying to figure things out :p

I currently have this problem :

I need a formula that adds an amount on a specific day of the week, every week..

for example : every week on monday, the formula should add 5

thanks in advance!

regards,

dree

[Fotis1991]

Hi and welcome to the forum.

Try with IF & WEEKDAY function.

[dree]

so something like this : =IF(WEEKDAY(DATE(2012;6;25);2)=1;C40+5;0) ?

[Fotis1991]

Try

=IF(WEEKDAY("25/06/12")=2,$C$40+5,0)

In my computer system, MONDAY, is 2nd day of the week.

[dree]

I still get something weird like : 30/01/1900 instead of a quantity number

[Fotis1991]

Change the format to General...

[dree]

okay, thx for the help!

[Fotis1991]

You are welcome!