Hello,
I need to create a formula that can tell if the date entered is:
1. present date
2. past date
3. future date
4. my birthday(24th march)
This formula needs to work any date, so i know that the "today" command needs to be used, that's all i know tho...
so...any help?
Hello,
Is this any use to you?
Formula:
Please Login or Register to view this content.
Last edited by sweep; 03-23-2018 at 06:09 AM. Reason: Workaround for the firewall issue
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Something like below?
=IF(Text(dateCell,"mmdd")="0324","Birthday",IF(dateCell<Today(),"Past",IF(dateCell>Today(),"Future","Present")))
Though I'd likely store Today() in another cell and reference that.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Place a space around any < > characters, should be ok thenOriginally Posted by sweep
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Or use font color code for black right after < or > operator.Apologies, I can't complete the formula as the site is firewalling me.
That's how I usually do it. So formula can be copied and pasted as is.
Administrative Note:
- We would love to continue to help you with your query, but first, before we can proceed…
- Please see Forum Rule #1 about proper thread titles and adjust accordingly...
HTH
Regards, Jeff
@Special K & CK76 - Thanks for the advise..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks