>
  1. Forum
  3. Political Opinions, Commentaries on Current Issues
  5. The Water Cooler!
  7. Excel help

Excel help

  • Nargis
  • Topic Author
  • Visitor
  • Visitor
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.

  • BK
  • Visitor
  • Visitor
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.

  • BK
  • Visitor
  • Visitor
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.

  • Nargis
  • Topic Author
  • Visitor
  • Visitor
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.

  • BK
  • Visitor
  • Visitor
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.

  • Nargis
  • Topic Author
  • Visitor
  • Visitor
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.

  • Nargis
  • Topic Author
  • Visitor
  • Visitor
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 Water Cooler!
  7. Excel help
Time to create page: 0.196 seconds
ketchimWorld Cup T20 Umpire cheat us on Hettie LBW(05.03.2026, 18:01)(18:01)0
ketchimIndia win Semi FinalT20 World Cup by 7 runs vs. England !(05.03.2026, 12:43)(12:43)0
RolandAn Alabama circuit judge on Monday denied Alabama basketball player Charles Bediako’s motion for a preliminary injunction, ending the 7-foot center’s collegiate eligibility and his season with the Crimson Tide.(10.02.2026, 11:32)(11:32)0
JacquelineICC travel to Pakistan and Game will Play !(10.02.2026, 10:24)(10:24)0
JosephineSeattle opened as favorites, and they've earned that right, with fantastic play on both sides of the ball. We are leaning in their direction in what should be a high-scoring Super Bowl.(03.02.2026, 18:05)(18:05)0
MaleahBREAKING: The government of Pakistan has said that Pakistan will boycott their T20 World Cup match against India(01.02.2026, 11:02)(11:02)0
ketchimGot Florida Hass theodday from my buddy visiting here !(22.01.2026, 19:37)(19:37)0
ketchimICC tell Bangladseh they will be REPLACED !(22.01.2026, 19:17)(19:17)0
MaleahGuyanese people in Florida can't just go and catch a dozen or two dozen HASSA; they have to catch over 5 million.
This is called Greed		(07.01.2026, 13:14)(13:14)1
MaleahNow that Joe Root has 2 centuries in Australia, I assume those Australian fans, who said he couldn’t be classed as great unless he achieved that, will now say he is?? Given that the great Steve Smith has never scored a test ton in Pakistan….(05.01.2026, 12:31)(12:31)0
MaleahThe Bangladesh Cricket Board has formally asked the ICC to move all of Bangladesh’s matches out of India, citing safety and security concerns.

#T20WorldCup		(04.01.2026, 14:18)(14:18)0
Gwen20(03.01.2026, 13:42)(13:42)0
Gwen(select 198766*667891 from DUAL)(03.01.2026, 13:42)(13:42)0
Gwen(select 198766*667891)(03.01.2026, 13:42)(13:42)0
Gwen@@iBQ3X(03.01.2026, 13:42)(13:42)0
Gwen20'"(03.01.2026, 13:42)(13:42)0
Gwen20(03.01.2026, 13:42)(13:42)0
Gwen20'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'(03.01.2026, 13:42)(13:42)0
Johan20(03.01.2026, 13:42)(13:42)0
Gwen20*DBMS_PIPE.RECEIVE_MESSAGE(CHR(99)||CHR(99)||CHR(99),15)(03.01.2026, 13:41)(13:41)0
Gwen20F4owsBb6')) OR 756=(SELECT 756 FROM PG_SLEEP(15))--(03.01.2026, 13:41)(13:41)0
Gwen20axQfaI3h') OR 505=(SELECT 505 FROM PG_SLEEP(15))--(03.01.2026, 13:40)(13:40)0
Gwen20GCVWFMgw' OR 960=(SELECT 960 FROM PG_SLEEP(15))--(03.01.2026, 13:40)(13:40)0
Gwen20-1)) OR 426=(SELECT 426 FROM PG_SLEEP(15))--(03.01.2026, 13:39)(13:39)0
Gwen20-1) OR 573=(SELECT 573 FROM PG_SLEEP(15))--(03.01.2026, 13:39)(13:39)0
Gwen20-1 OR 604=(SELECT 604 FROM PG_SLEEP(15))--(03.01.2026, 13:38)(13:38)0
Gwen20ZWzru47i'; waitfor delay '0:0:15' --(03.01.2026, 13:38)(13:38)0
Gwen20-1 waitfor delay '0:0:15' --(03.01.2026, 13:38)(13:38)0
Gwen20-1); waitfor delay '0:0:15' --(03.01.2026, 13:37)(13:37)0
Gwen20-1; waitfor delay '0:0:15' --(03.01.2026, 13:36)(13:36)0
Gwen(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/(03.01.2026, 13:36)(13:36)0
Gwen200"XOR(20*if(now()=sysdate(),sleep(15),0))XOR"Z(03.01.2026, 13:36)(13:36)0
Gwen200'XOR(20*if(now()=sysdate(),sleep(15),0))XOR'Z(03.01.2026, 13:35)(13:35)0
Gwen20*if(now()=sysdate(),sleep(15),0)(03.01.2026, 13:35)(13:35)0
Gwen-1" OR 18=18 or "FwfsM7AR"="(03.01.2026, 13:34)(13:34)0
Gwen-1" OR 3*2<5 or "FwfsM7AR"="(03.01.2026, 13:34)(13:34)0
Gwen-1" OR 5*5=26 or "FwfsM7AR"="(03.01.2026, 13:34)(13:34)0
Gwen-1" OR 5*5=25 or "FwfsM7AR"="(03.01.2026, 13:34)(13:34)0
Gwen-1' OR 641=641 or 'eESQ4mw4'='(03.01.2026, 13:34)(13:34)0
Gwen-1' OR 3*2<5 or 'eESQ4mw4'='(03.01.2026, 13:34)(13:34)0
Gwen-1' OR 5*5=26 or 'eESQ4mw4'='(03.01.2026, 13:34)(13:34)0
Gwen-1' OR 5*5=25 or 'eESQ4mw4'='(03.01.2026, 13:34)(13:34)0
Gwen-1" OR 3*2>5 --(03.01.2026, 13:34)(13:34)0
Gwen-1" OR 3*2>999 --(03.01.2026, 13:34)(13:34)0
Gwen-1" OR 5*5=25 --(03.01.2026, 13:34)(13:34)0
Gwen-1' OR 5*5=26 --(03.01.2026, 13:34)(13:34)0
Gwen-1 OR 3*2>5(03.01.2026, 13:34)(13:34)0
Gwen-1 OR 3*2>999(03.01.2026, 13:34)(13:34)0
Gwen-1 OR 5*5=25(03.01.2026, 13:34)(13:34)0
Gwen-1 OR 3*2>5 --(03.01.2026, 13:34)(13:34)0
Ariah
Powered by The Krotek
Go to top