| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
count weeks
hello
how can we count how many weeks we have between a specific date in a cell (A1 for example) and today? -- Croco |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
count weeks
With today in b1 try this:-
=ABS((B1-A1)/7) The cell this is in must be formatted as 'Number' Mike "Croco" wrote: hello how can we count how many weeks we have between a specific date in a cell (A1 for example) and today? -- Croco |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
count weeks
Croco,
I didn't like the decimal weeks the previous formula gives so try this instead:- =INT(ABS((B1-A1)/7))&" Weeks "&MOD(ABS(A1-B1),7)& " Days" "Croco" wrote: hello how can we count how many weeks we have between a specific date in a cell (A1 for example) and today? -- Croco |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
count weeks
=weeknum(TODAY())-weeknum(A1)
you may want to adjust by 1 and compensate for day of the week. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Croco" wrote in message ... hello how can we count how many weeks we have between a specific date in a cell (A1 for example) and today? -- Croco |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the number of even weeks in the current month. | Excel Worksheet Functions | |||
| This weeks funnies | Excel Discussion (Misc queries) | |||
| how to count weeks from date "X" then calculate | Excel Worksheet Functions | |||
| Calculate 52 weeks | Excel Worksheet Functions | |||
| calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
Linear Mode
