+- Cricket Windies (https://cricketwindies.com)
+-- Forum: What’s on Your Mind? (https://cricketwindies.com/forum-3.html)
+--- Forum: The Water Cooler! (https://cricketwindies.com/forum-4.html)
+--- Thread: Excel help (/thread-4982.html)
Re: Excel help - Nargis - 02-15-2012
eff this
im going to the gym
Re: Excel help - ketchim - 02-15-2012
Everybaddy keeps telling me watch out for this :
Wednesday , February 29 ......
Re: Excel help - Nargis - 02-15-2012
why?
Re: Excel help - Captain - 02-15-2012
Coming of the prophet
Re: Excel help - ketchim - 02-15-2012
Cause all preset systems from 4 years ago :
will be out a whack !
errrr...by 1 day :
until reset for March 1st ...
Re: Excel help - Artemisback - 02-15-2012
subs can;t be wrong. she;s never wrong
hocked: :kiss: :cheesy:
Re: Excel help - Ryan - 02-15-2012
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?
Re: Excel help - ketchim - 02-15-2012
she watching the numbers on the treadmill ...
2 kilometres per hour ::lol:: ::lol::
Re: Excel help - Nargis - 02-15-2012
[quote author=Vivekananda link=topic=63573.msg398170#msg398170 date=1329348023]
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?
[/quote]
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?
Re: Excel help - BK - 02-16-2012
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.