Prev: isnumber search
Next: Leaving a formula cell blank when data has not yet been added.
From: Siralec on 20 May 2010 17:57
User enters a specific date, I'd like to round that entry to the end of the
month
From: Gary''s Student on 20 May 2010 18:05
With a date in A1:

=DATE(YEAR(A1),MONTH(A1)+1,0)

step into the next month and then back one day.
--
Gary''s Student - gsnu201003


"Siralec" wrote:

> User enters a specific date, I'd like to round that entry to the end of the
> month
From: T. Valko on 20 May 2010 21:37
Another way...

This requires the Analysis ToolPak add-in be installed for Excel versions
prior to Excel 2007.

A1 = some date

=EOMONTH(A1,0)

Format as Date

--
Biff
Microsoft Excel MVP


"Siralec" <Siralec(a)discussions.microsoft.com> wrote in message
news:47FD80F3-FFED-4855-82B0-4D24DB8DF338(a)microsoft.com...
> User enters a specific date, I'd like to round that entry to the end of
> the
> month


From: Ron Rosenfeld on 20 May 2010 21:39
On Thu, 20 May 2010 14:57:01 -0700, Siralec <Siralec(a)discussions.microsoft.com>
wrote:

>User enters a specific date, I'd like to round that entry to the end of the
>month

=A1-DAY(A1)+32-DAY(A1-DAY(A1)+32)

If it needs to be done in the SAME cell as the entry, you could use a VBA Event
triggered macro.
--ron
 | 
Pages: 1
Prev: isnumber search
Next: Leaving a formula cell blank when data has not yet been added.