Hi there,
Can you set a coloumn to count down numbers by a weekly basis. ie
on monday the number will be 5
Next monday the number will be changed to 4 automatically
and so on.
Not sure wether Excel can do this but i am a complete amateur.
Many thanks
Hi,
As an example with next monday cell A1 =DATE(2006,10,30)
type in cell B1
=IF(WEEKDAY(A1)=2,5-((A1-DATE(2006,10,30))/7),"")
for the formula to work as you wish, cell A1 should contain =Today()
HTH
Carim
subtract a date from Now() and take the Mod of that divided by 7Originally Posted by ponyboy
something like put 2/12/2006 in A1 ( a date 5 weeks hence)
and use
=INT(MOD(((A1-NOW())/7),7))
hth
---
added, If I could type more quickly I wouldn't cross-post so often.
Last edited by Bryan Hessey; 10-27-2006 at 08:16 AM.
Si fractum non sit, noli id reficere.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks