Hi,
I have the below formula, but if the result is for example 94 years,9 months, 1 Days, is there a way for it to read "1 Day" instead of "1 Days"?
I've tried using the IF statement and I suppose it's a way but it doesn't work.....may be not putting it in the right place or may be an easier way?
=DATEDIF(H4,TODAY(),"y")&" years,"&DATEDIF(H4,TODAY(),"ym")&" months, "&DATEDIF(H4,TODAY(),"md")&" days"
Maybe this:
=DATEDIF(H4,TODAY(),"y")&" years,"&DATEDIF(H4,TODAY(),"ym")&" months, "&DATEDIF(H4,TODAY(),"md")&IF(DATEDIF(H4,TODAY(),"md")>1," days"," day")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Just a thought Ali... since the OP wants the singular "day" for one day I'd be willing to be he/she would also want singulars for month and year when there is only one of those as well.
I'm sure, Rick, but I am also sure he can work the other two out from my example.
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
No. I couldn't. I did try several ways and i can so please don't judge people you don't know so lightly. I told I am very green at nesting and in general (compare to wizards like yourselves).Originally Posted by AliGW
That formula to start with is not mine at all in the first place just trying to be half as good as you are. Please dont just take assumptions so freely and don't be so rude
Can you please advise how to unsubscribe?
What is rude about what I said? If you couldn’t work it out, all you had to do was ask.
I have made no judgement at all. And there is no clue in the opening post that the formula wasn’t yours. Goodness! What a fuss!
There’s no need. If you don’t want our help or to comply with simple rules about cross-posting, then I suggest you go and find another forum.
I am closing this thread, as you have refused to acknowledge the cross posting either here or on the other forum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks