Cell should calculate the date of monday

[navin]

Hi,

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

Regards,
Navin

 

[Niek Otten]

Hi Navin,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I want to know if a cell can calculate the date for the first monday of
| every month.
|
| Regards,
| Navin
|

 

[Peo Sjoblom]

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

 

[navin]

Thank you for the help.

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