Re: Days in Month Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JulieD (julied_ng_at_hctsReMoVeThIs.net.au)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 13:43:48 +0800

Hi Joe

there's a whole heap of different answers under the thread you started on
the 25th, have you checked them out?
some of us thought that you wanted e.g. 07/19/2003 - "19" returned
others thought you wanted the number of days in July returned, ie "31"
solutions for both of these scenarios have been provided.

Let us know how you go.

Cheers
JulieD

"Joe" <jgangi@yahoo.com> wrote in message
news:8d76041f.0403251715.230aa896@posting.google.com...
> I am trying to write a formula that will look at a cell with a date in
> it, for example, cell "A1" has 07/31/2003 in it I want cell "A2" t
> return the days value for that month. In this example 31. I have
> tried a bunch of date formulas and have had no luck. Any help out
> there would be appreciated. Thanks.

Relevant Pages

  • sum true/false
    ... Is there anyway of summing a bunch of rows, ... I tried changing the cell to a number. ... but no luck. ...
    (microsoft.public.excel.programming)
  • Re: The joy of garbage collection
    ... SIOD does it with a linked list of cells on the heap. ... Every unmarked cell that has a type tag ... The heap itself is an array or arrays of a C union. ...
    (comp.lang.lisp)
  • Re: _CrtIsValidHeapPointer and templates
    ... When you say that Cell is a POD type, I assume it is declared as a native ... I have a native DLL which is called from a managed application. ... everything works fine until the function making ... std::vector are allocated on the DLL's heap but when the function ...
    (microsoft.public.dotnet.languages.vc)
  • Boxing and Unboxing of Value-Types when passed to a method call
    ... bunch of questions which make this very controversial:-0) ... Can somebody describes what exactly happens in the stack and (probably in ... the heap) when this code is executed? ... Raza Alirezaei ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Help! problem running a script.
    ... I'm using tcl8.5, sqlite, xotcl and a c library of mine. ... [and my heap is broken] ... Then good luck. ...
    (comp.lang.tcl)