Add automatically a number to a cell each time the week changes

B

Bill

hi to evereyone
i want to make a function that i have in cell a1 a number
5 and each time the week changes, to add to that number
the value 1
eg. if at that time have number 5 the next monday i want
to have six
and the following maonday the number 7, but through teh
week to stay as it is. for this one as five, for the next
one as 6 , etc...
I tried to bring in a cell the current day and work with
the function IF but it didn' t work
Doeas anyone can help me?

Regards BIll
 
N

Niek Otten

Manos/Bill,

I answered your question (first version) half an hour ago

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
P

Paul

Bill said:
hi to evereyone
i want to make a function that i have in cell a1 a number
5 and each time the week changes, to add to that number
the value 1
eg. if at that time have number 5 the next monday i want
to have six
and the following maonday the number 7, but through teh
week to stay as it is. for this one as five, for the next
one as 6 , etc...
I tried to bring in a cell the current day and work with
the function IF but it didn' t work
Doeas anyone can help me?

Regards BIll
Click to expand...

Please don't post to more than one newsgroup. Your post was answered in
..misc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign each week number to corresponding month of the year 5
make a function that add number 1 in another number 3
Importing cells frmom a calendar workbook 4
How can I add down a list a specified number of cells? 9
cells are automatically dividing each # I put in by 10!!! 5
finding 10 smallest numbers from last 20 input 8
combining COUNTIF and OR functions 3
Fill Cells with same number in three rows then skip to next number 2

Top