Re: working with dates
- From: "Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 31 Jan 2006 12:14:16 -0000
Hi
=DATE(YEAR(TODAY()),MONTH(TODAY()),1) for first of month
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0) for last of month
works on the 0th day of a month is equal to last day of previous month
so
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),1),"mm/dd/yyyy") &" - " &
TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+0,0),"mm/dd/yyyy")
--
Regards
Roger Govier
"Hru48" <Hru48.22hzpy_1138708802.0311@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Hru48.22hzpy_1138708802.0311@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Hey all,
>
> I need a cell to work to return the first and last day of the month it
> is in without me having to type anything in. In the format
> mm/dd/yyyy -
> mm/dd/yyyy
>
> I was thinking I could use date(now) and then use date difference to
> figure this out but i'm not too sure on the syntax.
>
> Any help would be great.
>
> Thanks.
>
>
> --
> Hru48
> ------------------------------------------------------------------------
> Hru48's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=24895
> View this thread:
> http://www.excelforum.com/showthread.php?threadid=506719
>
.
- References:
- working with dates
- From: Hru48
- working with dates
- Prev by Date: working with dates
- Next by Date: Re: Macro to eliminate extra space
- Previous by thread: working with dates
- Next by thread: Re: working with dates
- Index(es):
Relevant Pages
|
