ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Date Change (https://www.excelbanter.com/excel-programming/296223-date-change.html)

Ben Allen

Date Change
 
Hi,
When a user clicks a button on my worksheet a macro is run. This macro sets
a cell on a hidden sheet to be the current date. On Auto_open this date is
checked, if the current date is the cell value + 7 a message box is
displayed sayin "It is a week since you....". Is it possible to do instead
of + 7, + 1 month, as you cannot do +30 or +31 due to the varying days in a
month. Any suggestions?
Thanks
--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"




All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com