Macro to complete date form
Closed
DazJ
Posts
4
Registration date
Tuesday February 24, 2015
Status
Member
Last seen
February 25, 2015
-
Feb 24, 2015 at 05:24 PM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Feb 25, 2015 at 06:44 PM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Feb 25, 2015 at 06:44 PM
Related:
- Macro to complete date form
- Could not complete this operation. there was not enough memory available - Guide
- Wpan full form - Guide
- Spell number in excel without macro - Guide
- Facebook group disabled appeal form - Guide
- Macro excel download - Download - Spreadsheets
1 response
cmarzahn
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Feb 24, 2015 at 05:45 PM
Feb 24, 2015 at 05:45 PM
Don't really need a macro. I often put a "Driver" worksheet in workbooks I build. One of the drivers (or inputs) could be the start date for the range of dates on the other sheets.
Within the functions, consider using =now() in combo at the right times.
For example, I build 'em so the now() function updates files to the current year when opened.
To find the end of the month, for example, it might go like this:
=EOMONTH(NOW(),0)
To get the day of the month you could use:
=DAY(NOW())
To get the Weekday is a bit more involved.
=CHOOSE(WEEKDAY(NOW()),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
Hope that helps!
Within the functions, consider using =now() in combo at the right times.
For example, I build 'em so the now() function updates files to the current year when opened.
To find the end of the month, for example, it might go like this:
=EOMONTH(NOW(),0)
To get the day of the month you could use:
=DAY(NOW())
To get the Weekday is a bit more involved.
=CHOOSE(WEEKDAY(NOW()),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
Hope that helps!
Feb 24, 2015 at 06:03 PM
Feb 24, 2015 at 06:14 PM
Feb 24, 2015 at 10:23 PM
Look for the "drivers" sheet at the end of the worksheets.
Put the Start of the month in the yellow cell
It finds the day of the end of the month.
Fill in the dates of the first week of the month (Yellow) and the rest happens automatically. Saved a copy to the same place on Google Drive.
https://docs.google.com/spreadsheets/d/1i6KFwZHJLTD0_6uXvsygV1cC9vK5oh8o-rkZyclCOD4/edit?usp=sharing
Feb 25, 2015 at 05:17 AM
Yeah, everything is working well here, just need to add conditional formatting. If the days of the week = "0" or " " then grey the cells below out.
Feb 25, 2015 at 06:44 PM