>
  1. Forum
  3. Political Opinions, Commentaries on Current Issues
  5. THE CONVERSATION TREE
  7. Excel help

Excel help

More
15 Feb 2012 17:00 #75802 by Nargis
i want to subtract multiple DATE cells to me days

how do i do it?

Please Log in or Create an account to join the conversation.

More
15 Feb 2012 17:13 #75805 by ketchim
You wanna go on multiple Dates  ?  :shocked:

Lemme see IF  I can write a macro for that ..

Please Log in or Create an account to join the conversation.

More
15 Feb 2012 17:15 #75806 by BK
2/16/2012, 2/17/2012, 2/18/2012, 2/19/2012
Set the date in the column like the above and then  insert your formula accordingly but make sure that you set the criteria as date and number accordingly

Please Log in or Create an account to join the conversation.

More
15 Feb 2012 17:19 #75808 by ketchim
Subs , she trying to reset February 29 th  :

Leap Years are a Biatch !  ::lol::

Please Log in or Create an account to join the conversation.

More
15 Feb 2012 17:23 #75809 by BK
she need a time machine to do that  ::redcard::

Please Log in or Create an account to join the conversation.

More
15 Feb 2012 17:27 #75810 by Nargis
that doesnt work

i dont get days even if i change the cell format

i am almost thinking it cant be done

Please Log in or Create an account to join the conversation.

More
15 Feb 2012 17:29 #75811 by BK
then something is wrong with your excel setting (might be corrupted). because it should work once you change the format in the cells.

Please Log in or Create an account to join the conversation.

More
15 Feb 2012 17:31 #75812 by Nargis
no it doesnt

i am trying to subtract a date from April, from a date in March, from 3 dates in Feb

to give me the remaining days

Please Log in or Create an account to join the conversation.

More
15 Feb 2012 17:35 #75813 by ketchim
Add  1 day for a Leap Year ..

Please Log in or Create an account to join the conversation.

More
15 Feb 2012 17:38 #75814 by Nargis
leap year doesnt matter

Please Log in or Create an account to join the conversation.

  1. Forum
  3. Political Opinions, Commentaries on Current Issues
  5. THE CONVERSATION TREE
  7. Excel help
Time to create page: 0.241 seconds
Rachelwhy captcha is taking too much time????(22.11.2024, 10:33)(10:33)0
Annabella?Motie the batsman!? Its becoming a habit. He came in at117/8 and left at 166/9

Motie smashed 33(14)

He is world Number 2 bowler but probably wants a promotion to Motie the all rounder.

(PIC ESPNcricinfo )
#kaieteurnewspaper
#KaieteurNews
#sports
#cricket
#WIvsENG		(10.11.2024, 11:11)(11:11)0
AnnabellaBreaking: Dallas Cowboys QB Dak Prescott is planning to undergo season-ending surgery on his partially torn hamstring, pending the opinion of one final specialist, sources told Adam Schefter.(09.11.2024, 17:56)(17:56)0
AnnabellaAlzarri Joseph ban for two matches(07.11.2024, 18:41)(18:41)0
AnnabellaWhy New Zealand & South Africa don't play more test matches like Australia, England and India?(03.11.2024, 14:06)(14:06)0
SawyerPresident Ali lauds QC as symbol of excellence at 180th anniversary event(22.10.2024, 05:15)(05:15)0
EllieSerious Comment! Guyana lost because GAW forgot to switch off the stadium lights!(07.10.2024, 19:33)(19:33)0
EllieThey have more astronauts in the Hubble Space Telescope than attendees in Nigel Latrine meeting.(06.10.2024, 15:48)(15:48)0
JohannaPollard: We need to produce next batches of Bravos, Pollards, Narines(27.09.2024, 16:47)(16:47)0
JohannaDwayne Bravo parts ways with CSK, joins KKR as mentor for IPL 2025(27.09.2024, 16:38)(16:38)0
EllieDo you recall the famous Village Umpires. The ball only touch the pad Or wicket keeper appeal. Is OUT!(12.09.2024, 14:51)(14:51)0
EllieStatement from CPL: "Sherfane Rutherford is leaving the St. Kitts and Nevis Patriots squad due to personal reasons and will take no further part in the 2024 Republic Bank Caribbean Premier League (CPL). The Patriots will name a replacement in due course."

Rutherford has not had the best of seasons, with scores of 1, 0, 34 and 1.

(Photo: CPL/Getty Images)

#sport #news #newsroom #newsroomguyana #guyana		(11.09.2024, 19:05)(19:05)0
AldoJoe Root has never been featured in any Test XI Greatest. Maybe because his publicity profile is low. But it would be difficult not to include him!(03.09.2024, 10:22)(10:22)0
IslaGTT enters three-year endorsement partnership with cricketer, Shamar Joseph(30.08.2024, 17:17)(17:17)0
Islawest indies winn(27.08.2024, 18:21)(18:21)0
IslaWest Indies need 13 runs in 26 balls(27.08.2024, 18:17)(18:17)0
IslaHetmyer, FOUR, only 18 now.(27.08.2024, 18:16)(18:16)0
JerichoWho the hell send shamar Joseph to bat at number 11(16.08.2024, 11:32)(11:32)0
JerichoHappy Athanaze made runs, but in my opinion he could have been out anytime.(12.08.2024, 09:29)(09:29)0
JerichoBally Khaman
The Caribbean fans asking for more test series per a year but WI can't put together a proper test team eh ?		(03.08.2024, 18:48)(18:48)0
MarcoRiley Gaines laid into Brittney Griner for kneeling during the National Anthem. “You don’t have to sing or anything, but you need to show some respect for the country that saved you from a Russian Gulag.” ???(03.08.2024, 12:41)(12:41)0
MarleighLooking for PM...(20.07.2024, 20:51)(20:51)0
AbdullahIsraeli Prime Minister Benjamin Netanyahu makes surprise Gaza visit(20.07.2024, 17:06)(17:06)0
ketchimhopefully day 3 goes as well as day 2 !(19.07.2024, 15:25)(15:25)0
Sylviarally(18.07.2024, 18:00)(18:00)0
Braxtone(18.07.2024, 08:08)(08:08)0
SantinoShamar Joseph & Gudakesh Motie Late Tour Arrival(05.07.2024, 15:23)(15:23)0
Gabriel30 from 30 balls and lost.
I have no respect for South africa!!!		(29.06.2024, 13:18)(13:18)0
AldoI'm confused on how a funeral home can raise the price of a funeral service and blame it on the cost of living.(27.06.2024, 19:35)(19:35)0
BrynleeShaheen Afridi has signed for Toronto Nationals in the Global T20 Canada, weeks after withdrawing from a £100,000 contract with Welsh Fire in the Hundred

Short-form leagues need better regulation: this should be enough for the ECB to ban Shaheen for the 2025 edition, for example		(22.06.2024, 13:48)(13:48)0
GabrielI guess all west indies fans will be rooting for England this morning how ironic(21.06.2024, 09:54)(09:54)0
GabrielFormer India fast bowler David Johnson has passed away at the age of 52 after falling from his balcony, as per reports.(20.06.2024, 06:07)(06:07)0
GabrielCan usa win the cup(19.06.2024, 08:32)(08:32)0
NasirPakistan's nervy run-chase condemns Ireland to a winless World Cup campaign(16.06.2024, 14:18)(14:18)0
GabrielUsa goes to super8(14.06.2024, 13:15)(13:15)0
NasirSaurabh Netravalkar and Harmeet Singh: two Mumbai boys living the American cricket dream(13.06.2024, 17:18)(17:18)0
NasirMotie among contenders for ICC Player of the Month(11.06.2024, 16:52)(16:52)0
ketchimUSA created History with a Super Over Victory !(07.06.2024, 09:20)(09:20)0
Nasirusa vs pakistan(06.06.2024, 10:31)(10:31)0
WarrenIcc may have to ban worldcup matches in barbados too much rain(04.06.2024, 18:51)(18:51)0
SaulChase rescues West Indies for a winning start(02.06.2024, 17:46)(17:46)0
ketchim137 - after 19 : WIN(02.06.2024, 13:45)(13:45)0
ketchimPNG : 136 - 8 after 20(02.06.2024, 11:05)(11:05)0
WarrenCome and experience the vibrant atmosphere at 230 fifth Rooftop Bar! Open all year long, we're the perfect spot to enjoy the spring and summer seasons under the sky.

No reservations required—walk-ins are always welcome! Whether you're looking to unwind with refreshing drinks or indulge in delicious food, our rooftop offers stunning views that promise unforgettable evenings.

Join us at 230 Fifth Rooftop Bar for a taste of the good life, where every visit is more than just a meal—it's a celebration!		(01.06.2024, 10:18)(10:18)0
WarrenI heard Australia played with 9 players v WI in the warm up match again
Players still absent		(31.05.2024, 16:23)(16:23)0
AldoWindies move into 4th place on T20i rankings. Let's keep climbing(29.05.2024, 12:34)(12:34)0
Aldo? BREAKING ?

Former Australia opener Joe Burns will now play for Italy, aiming to help them qualify for the T20 World Cup 2026 in honor of his late brother and grandparents. ????

Burns' brother, Dominic, passed away in February this year. With the 34-year-old not receiving a contract from Queensland for 2024-25, he decided to make the switch.

He will wear the number 85 jersey to honor his brother. ❤️

#JoeBurns #Australia #Cricket #Italy #T20WorldCup #Sportskeeda		(28.05.2024, 12:29)(12:29)0
AldoPandya has added His mother in his every bank accounts and property even before marriage.

So basically if divorce happens, Natasa Stankovic will get nothing from hardik Pandya ?

Gujarati boy for a reason ?		(27.05.2024, 11:14)(11:14)0
JourneeW.I. beat Saffies 1st T20.(23.05.2024, 18:41)(18:41)0
JourneeWest Indie Beat South Africa in 1st T20Jamaica Sabina Park(23.05.2024, 18:39)(18:39)0
Axton
Powered by The Krotek
Go to top