Re: First day of week-Monday.

Hello Peo Sjoblom

Thank you very much!

Similary how can i return below dates based on today()

1. First day of the month
2. Last day of the month

Regards,

Jimmy Joseph


Subject: Re: First day of week-Monday.
From: "Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com>
Newsgroups: microsoft.public.excel

Why use such a thing?

=TODAY()-WEEKDAY(TODAY()-2)

will return the same dates

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

=TODAY()-DAY(TODAY())+1

and

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Jimmy Joseph" <[email protected]> wrote in message
news:[email protected]...
> Hello Peo Sjoblom
>
> Thank you very much!
>
> Similary how can i return below dates based on today()
>
> 1. First day of the month
> 2. Last day of the month
>
> Regards,
>
> Jimmy Joseph
>
>
> Subject: Re: First day of week-Monday.
> From: "Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com>
> Newsgroups: microsoft.public.excel
>
> Why use such a thing?
>
> =TODAY()-WEEKDAY(TODAY()-2)
>
> will return the same dates
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> "It is a good thing to follow the first law of holes;
> if you are in one stop digging." Lord Healey

First =DATE(YEAR(TODAY),MONTH(TODAY(),1)
Last = DATE(YEAR(TODAY),MONTH(TODAY()+1,0)

HTH
--
AP

"Jimmy Joseph" <[email protected]> a écrit dans le message de news:
Xns97C995D3FF0B8jimmyjosephinboschco...c.cc.bosch.com...
> Hello Peo Sjoblom
>
> Thank you very much!
>
> Similary how can i return below dates based on today()
>
> 1. First day of the month
> 2. Last day of the month
>
> Regards,
>
> Jimmy Joseph
>
>
> Subject: Re: First day of week-Monday.
> From: "Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com>
> Newsgroups: microsoft.public.excel
>
> Why use such a thing?
>
> =TODAY()-WEEKDAY(TODAY()-2)
>
> will return the same dates
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> "It is a good thing to follow the first law of holes;
> if you are in one stop digging." Lord Healey