Forum: I have a simple message box that will insert today's date in the range I4:I7 but I'd like to insert a different date (a year earlier) in the range I8:I11. I know subtracting 365 from "= Date," won't work, but since I don't know the correct code, I've put it there so you can see what I'm hoping to achieve. Any help will be appreciated.
Please Login or Register to view this content.
It does work. You typed a comma and messed up the command.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Wow, too simple. Thank you mehmetcik.
JPDutch
BE AWARE, it does NOT work fro two reasons!!!
1. You have 3 calls of the Date function. The first call can be executed just before midnight and one of the next two calls after midnight.
2. Not all years have 365 days, I hope you know it.
The correct code:
Please Login or Register to view this content.
Sorry, I see now that I deleted two " by mistake. The correct code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks