| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare Current Date
I feel silly for not being able to figure this out.
How do I compare the users current system date, to a date I arbitaril pick. I'm making a calculator that will need to be updated every 6 months o so. I want to make a box pop-up when they open the calculator after sa December 31, 2004, directing them to our website for an update. How can I do this? Thank -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare Current Date
If Date #12/31/2004# Then 'Date is the current system date
MsgBox "You need to download the updated version" End If -Gitcyphe -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
| I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
![InnerChild[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
