Automatic update for dates

[jazzkid]

I am trying to create an attendance list for an organisation and set it up to automatically put in the Monday dates for each month in 2016.

I figure there is an easy way to do this with a formula - but can't find it. If anyone is has a solution I would really appreciate it.

I still can't upload excel files to here for some reason. I have put an example excel file converted to pdf to show what I want. I have done the January worksheet only.

 

[NARAYANK991]

Hi ,

Instead of converting the .xlsx file to .pdf , just rename the .xlsx file to .pdf and upload it ; whoever wishes to open the file , will rename it and then open it.

Narayan

 

[vletm]

@jazzkid
Something like this...