Auto counting
in [General]
|
Prev: I have 138 numbers, how do i get 15 random numbers from my dat
Next: Resolve Error in opening Excel File zip file from a CD?
From: ernie on 17 Mar 2010 02:45 I got dates under column A and days passed by since date in column A in Column B. How do I ask it to auto calculate the days passed with reference to the date in real time. Example: A B 5 march 2010 11days 10 march 2010 6days Given today's date is 17 march 2010 -- Thanks! help me
From: Jacob Skaria on 17 Mar 2010 02:51 Try =TODAY()-A1-1 & " days" -- Jacob "ernie" wrote: > I got dates under column A and days passed by since date in column A in > Column B. How do I ask it to auto calculate the days passed with reference to > the date in real time. > > Example: > > A B > 5 march 2010 11days > 10 march 2010 6days > > Given today's date is 17 march 2010 > -- > > Thanks! > > help me
From: ernie on 17 Mar 2010 03:02 thanks very useful much indeed. =) -- help me "Jacob Skaria" wrote: > Try > > =TODAY()-A1-1 & " days" > > -- > Jacob > > > "ernie" wrote: > > > I got dates under column A and days passed by since date in column A in > > Column B. How do I ask it to auto calculate the days passed with reference to > > the date in real time. > > > > Example: > > > > A B > > 5 march 2010 11days > > 10 march 2010 6days > > > > Given today's date is 17 march 2010 > > -- > > > > Thanks! > > > > help me
From: ernie on 17 Mar 2010 03:11 what if i want to exclude the weekends till today. possible ? Thanks -- help me "Jacob Skaria" wrote: > Try > > =TODAY()-A1-1 & " days" > > -- > Jacob > > > "ernie" wrote: > > > I got dates under column A and days passed by since date in column A in > > Column B. How do I ask it to auto calculate the days passed with reference to > > the date in real time. > > > > Example: > > > > A B > > 5 march 2010 11days > > 10 march 2010 6days > > > > Given today's date is 17 march 2010 > > -- > > > > Thanks! > > > > help me
From: Jacob Skaria on 17 Mar 2010 03:22
Try =SUMPRODUCT(INT((TODAY()-A1+WEEKDAY(A1-{2,3,4,5,6}))/7)) OR (From Analysis Tool Pak Add-In) =NETWORKDAYS(A1,TODAY()) -- Jacob "ernie" wrote: > what if i want to exclude the weekends till today. possible ? > > Thanks > -- > help me > > > "Jacob Skaria" wrote: > > > Try > > > > =TODAY()-A1-1 & " days" > > > > -- > > Jacob > > > > > > "ernie" wrote: > > > > > I got dates under column A and days passed by since date in column A in > > > Column B. How do I ask it to auto calculate the days passed with reference to > > > the date in real time. > > > > > > Example: > > > > > > A B > > > 5 march 2010 11days > > > 10 march 2010 6days > > > > > > Given today's date is 17 march 2010 > > > -- > > > > > > Thanks! > > > > > > help me |