Less
More
-
Posts: 8477
-
Thank you received: 2
-
-
Less
More
-
Posts: 97099
-
Thank you received: 45
-
-
Less
More
-
Posts: 8477
-
Thank you received: 2
-
-
Less
More
-
Posts: 12081
-
Thank you received: 20
-
-
Less
More
-
Posts: 97099
-
Thank you received: 45
-
-
15 Feb 2012 18:14 #75829
by ketchim
Cause all preset systems from 4 years ago :
will be out a whack !
errrr...by 1 day :
until reset for March 1st ...
Please Log in or Create an account to join the conversation.
-
artemis
-
-
Visitor
-
15 Feb 2012 18:18 #75832
by artemis
subs can;t be wrong. she;s never wrong :shocked:
:cheesy:
Please Log in or Create an account to join the conversation.
Less
More
-
Posts: 926
-
Thank you received: 0
-
-
15 Feb 2012 18:20 #75833
by Ryan
no matter what format, as long as its recognized as a date, should provide you a number in days.
if you format it as a number do you get anything?
Please Log in or Create an account to join the conversation.
Less
More
-
Posts: 97099
-
Thank you received: 45
-
-
Less
More
-
Posts: 8477
-
Thank you received: 2
-
-
15 Feb 2012 19:58 #75840
by Nargis
i get a number thats like -245698
i dont want that number -
Viviek here is what i want
I have to track my progress with my files (I have Multiple files)
everything is affected by Date (what date i review, date of request for docs, dates of issuances, date of review by others) - everything is a date.
I know what date I start, i know what date I have to end - there are dates in between(milestones lets say).
now i want to have the Data Bar in excel reflect a growth everytime i put in a date at each milestone, while i am getting close to the end date.....
how do i do that?
Please Log in or Create an account to join the conversation.
Less
More
-
Posts: 581
-
Thank you received: 0
-
-
16 Feb 2012 11:27 #75952
by BK
your syntax/formula should follow the same logic/sequence as when you are adding/substracting a string of numbers. you need to place in brackets the different variables - in this case the number of days between two dates. eg =(d20-b18)-(b12-a34) etc - which should give you the results you are looking for.
Please Log in or Create an account to join the conversation.
-
Forum
-
Political Opinions, Commentaries on Current Issues
-
THE CONVERSATION TREE
-
Excel help
Time to create page: 0.227 seconds