I need a formula to always calculate exactly 21 days from today's date.
I need a formula to always calculate exactly 21 days from today's date.
Last edited by phxfitness; 06-30-2015 at 03:01 PM.
Sorry, I mean 21 days prior to today's date.
=now()-21?
Try
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
TY, but I only need the date. Looks like a time stamp follows the date.
Did you try the TODAY()? It does not have a time stamp, but the NOW() does.
Perfect, Thank you.
No problem, glad it worked for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks