Help required on working with date

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: mzehr (mmzehr_at_hotmail.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 07:10:22 -0700

Hi,
use the following =EOMONTH("Date",-1)+1, where "date"
represents the cell address of the cells you want
evaluated. Note that you will need to have the analysis
toolpack addin installed to use this formula.

HTH.

>-----Original Message-----
>Hi
>
>I have dates in a column in dd-mmm-yy format, like
>
>29-Mar-04
>15-Apr-04
>13-May-04
>
>I want to put in the column adjecent to this date column
>the date starting with 1st day of each month like -
>
>01-Mar-04
>01-Apr-04
>01-May-04
>
>How can this be done by use of formula?
>
>I tried but do not get any clue to go futher.
>
>-Shanks
>.
>

Relevant Pages

  • Re: How do I get a cell to count values from a list dependent on anoth
    ... In cell C2 ... Roger Govier ... Contained within this tab where ... list STATUS is found the column adjecent to this has either D or F in ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Drop Down Box to Choose Time
    ... >> Use Data validation. ... >> still highlited goto the name box name ... >> select the cell that you want the time to be placed and goto data ... >> HTH ...
    (microsoft.public.excel.misc)
  • RE: Log UserID
    ... Sorry I assumed that you know how to place that in a cell (which is probably ... > HTH ... >> I have an excel file that pulls records from a database. ...
    (microsoft.public.excel.programming)
  • Re: Count time table
    ... > are a spanish provence, ... > Understand what i'm triyng to do? ... > It could be used an hide cell in which it could read the diference if the ... >> HTH ...
    (microsoft.public.excel.misc)
  • Re: correct date/days in a template
    ... Good point Marcello. ... so when you change the date on the K6 cell the weekday will change auto... ... You can alter that Template as much as you wish. ...
    (microsoft.public.excel.newusers)