Jump to content
Sign in to follow this  
RickB75

How can I get previous Calendar days of the week.

Recommended Posts

RickB75

I'm working on a timesheet script for myself. It will build a timesheet for me twice a month. I know how to use macros and get the current dates. I'm trying to figure out how to get the days of the week for each date. 

Example: If the 5th of the month was on a Tuesday, how can I tell the script to get that particular day of the week if I'm running the script on 20th of the month??

I was thinking about having the script to write the date and day to a text file each day and on the 16th and 1st of each month read the txt file and build the data that way. I wasn't sure if you guys could recommend a simpler way in stead of having to write a seperate txt file. 

Just curious....

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×