Share This:

I’ve been writing an application for work that requires me to display one weeks worth of data, starting on a Monday and ending on a Sunday. Below is the code that will find the first Monday and subsequent days dates.

This code would be useful for a calendar system, time-tracking application, project management etc.

‘** Get Today’s Date

‘** Get Which day of the week it is (number)
FirstDayOfTheWeek=Weekday(CurrentDate, 2)

‘** Find how many days until Sunday are left

Google Analytics – Short Review
Well, it’s taken 4 days but Google Analytics have finally kicked in. The amount of...

‘** Beginning of the week (Monday) Date
FindMonday=DateAdd(“d”,-FirstDayOfTheWeek, CurrentDate)+1

Skillshare - From Proficient To Pro

‘** End of the Week (Sunday) Date
FindSunday=DateAdd(“d”, LastDayOfTheWeek, CurrentDate)

A group of children raising their hands in the air
If you want to be a sponsor for your child, know that it won’t be as easy as you think it will be. If you want a reference, applying for a dependent visa will be more complex than a tourist visa or a working visa. Hence, you need to fully...

‘** Work out the dates for various days
Tuesday=DateAdd(“d”, FindMonday, 1)
Wednesday=DateAdd(“d”, FindMonday, 2)
Thursday=DateAdd(“d”, FindMonday, 3)
Friday=DateAdd(“d”, FindMonday, 4)
Saturday=DateAdd(“d”, FindMonday, 5)
Sunday=DateAdd(“d”, FindMonday, 6)

‘** Write Out the days and dates
Response.Write(“Mon – “&Monday&”<br>”)
Response.Write(“Tue – “&Tuesday&”<br>”)
Response.Write(“Wed – “&Wednesday&”<br>”)
Response.Write(“Thur – “&Thursday&”<br>”)
Response.Write(“Fri – “&Friday&”<br>”)
Response.Write(“Sat – “&Saturday&”<br>”)
Response.Write(“Sun – “&Sunday&”<br>”)

Please feel free to use the above code in any project – a mention would be nice too cheeky tongue

About The Author
Katy is always trying to be more productive one day at a time! Whether it's analogue, digital, motivational or psychological who'll try any system that will help her get things done and get organised. As well as running, she also loves making music and reviewing things.
  • Follow Katy Whitton on:
  • blank
  • blank
  • blank
  • blank
  • blank
  • blank
  • blank
  • blank
Please Note: This post may contain affiliate links. By clicking on these links you will not be charged any extra for purchasing goods and services from our preferred partners however may receive financial compensation which contributes to the running of the site. For more information please read our Advertising & Affiliate Disclosure Policy

Leave a Reply

Your email address will not be published. Required fields are marked *