Cell should calculate the date of monday

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

navin - 04 Jan 2007 17:08 GMT

Hi,

I want to know if a cell can calculate the date for the first monday of
every month.

Regards,
Navin

Reply to this Message

Niek Otten - 04 Jan 2007 17:22 GMT

Hi Navin,

Look here:

http://www.cpearson.com/excel/DateTimeWS.htm#LastWeekday

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
[quoted text clipped - 3 lines]
| Regards,
| Navin

Reply to this Message

Peo Sjoblom - 04 Jan 2007 17:24 GMT

Yes,

put the date in A1

=DATE(YEAR(A1),MONTH(A1),8)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),6))

will give you the first Monday of the date you put in A1, courtesy of
the date master Daniel Maher

If you put the year in A1 and the month number (like 3 for March etc) in
B1 you can use

=DATE(A1,B1,8)-WEEKDAY(DATE(A1,B1,6))

Regards,

Peo Sjoblom

> Hi,
>
[quoted text clipped - 3 lines]
> Regards,
> Navin

Reply to this Message

navin - 04 Jan 2007 19:45 GMT

Thank you for the help.

> Yes,
>
[quoted text clipped - 21 lines]
> > Regards,
> > Navin

Reply to this Message

Rate this thread: