LinkBack URL
About LinkBacks
Is there a way to do this exact thing, but be 48 hours instead?
Please Login or Register to view this content.
Is there a way to do this exact thing, but be 48 hours instead?Please Login or Register to view this content.
This will be true when A5 is more than 48 hours prior to the start of today. If you want it to be more than 48 hours prior to the time at the moment, then use NOW instead of TODAY.
Formula:
Please Login or Register to view this content.
Last edited by 6StringJazzer; 05-13-2016 at 11:21 AM. Reason: Got A5 and TODAY reversed, fixed it.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
What you need to understand about dates and times in excel is...
a date is just a number representing the number of days passed since 1/1/900...and then formated in a way that we recognise as a date. So, for instance, today (Fri May 2016) is actually 42503
Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75
so if you need to text for (exactly) 48 hours, that is really just 2 (days)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks