LinkBack URL
About LinkBacks
help please.
SIMPLE QUESTION.
The column i am interested is "F". So, if columns "C" has a date, I want column "F" to give me a daycount. If column "C" doesn't have a date, i want it to show "pending review".
PLEASE HELP.
thanks
help please.
SIMPLE QUESTION.
The column i am interested is "F". So, if columns "C" has a date, I want column "F" to give me a daycount. If column "C" doesn't have a date, i want it to show "pending review".
PLEASE HELP.
thanks
Not sure what you where you are getting the day count from, but this will subtract B8 from todays date. Place in column F
Formula:
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
Since dates are numbers I know of no definite way to distinguish what is a date and what is not.
The best I can do is suggest a comparison value reasonably large enough to distinguish a likely date from a smaller non-qualifying number.
Try thisFormula:Please Login or Register to view this content.
If there can be a date < 40000 select another large number greater than the latest date anticipated.
Dave
hi tom,
that's one of my questions too, how can I mark it as solved and how can I add good rep to you????.
thanks
To mark as solved, go to the top of your fist post, click thread tools then click solved.
To add rep, click Add Reputation with the start next to it from within one of my posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks