Cell should calculate the date of monday

  • Thread starter Thread starter navin
  • Start date Start date
N

navin

Hi,

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

Regards,
Navin
 
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
 
Thank you for the help.

Peo said:
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
Click to expand...
 
Back
Top