dubyayoung
New member
- Joined
- Oct 5, 2012
- Messages
- 11
- Reaction score
- 0
- Points
- 0
I have a worksheet that is used to collect data throughout the month and year, and I need to reset the month and year start data at the beginning of each new month and year. I have macros for that, but I want to set a condition that will only allow the macros to run if the date is the 1st day of the month, or the 1st day of the fiscal year (July 1 in this case) to ensure an accurate new starting point. I would also like to write an error message that will pop up if the macro is used on any day other than the 1st.
There is a date cell in the worksheet that may be able to be referenced for the formula (cell I1 for reference), but I don't really know. I am using the formula =TODAY() for the date, and having it display as Monday, September 01, 2014.
If getting the July 1 date is too difficult I can just use the monthly condition for the annual reset.
Any thoughts or help is appreciated!
There is a date cell in the worksheet that may be able to be referenced for the formula (cell I1 for reference), but I don't really know. I am using the formula =TODAY() for the date, and having it display as Monday, September 01, 2014.
If getting the July 1 date is too difficult I can just use the monthly condition for the annual reset.
Any thoughts or help is appreciated!