Search results

That's the magic of Excel :)

It's surprising how quickly these come along as you get older - Happy Birthday my friend :)

Well if you add 1000 days to 00/00/1900 you get 26/09/1902, so it's got something to do with that.........what that is.......your guess is as good as mine.

Hi @akay47, Welcome to the forum, take a look at this previous question, it may help http://chandoo.org/forum/threads/rank-changing-the-sequens-of-duplicate-values.24731/#post-148676

Well done, keep up the good work :cool:

Hi, Can you post a sample so that someone can help you find"DP" and its associated 7 characters? http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705

This should work =IF(AND(G$2>=$C3,G$2<=IF(LEN($D3)=0,TODAY(),$D3)),1,0) Copy across and down Alternative =IF(AND(G$2>=$C3,G$2<=IF($D3="",TODAY(),$D3)),1,0)

Congratulations on reaching the mark! :cool:

How about this way? http://www.pcreview.co.uk/threads/hide-cell-values-based-on-a-condition-in-another-cell.2947547/

@Luke M Thanks for restoring the link ;)

@vwwnab Hi, I've asked Luke to reinstall the link so that it works for you ..... give him a little time as he may be sleeping!

See previous post here, it may help? http://forum.chandoo.org/threads/excel-2013-out-of-resources.23485/

What happens when you use Copy/Paste Special/ All

@Hui... I'm surprised they haven't asked you to contribute to the summit with your knowledge of Excel, I'm sure you could teach them a thing or two

Are you going @bobhc ?

Hi @Sasi Kumar To either formula just add to the end +TIME(23,0,0) Then custom format the cell to dd/mm/yyyy hh:mm:ss

Hi @Sasi Kumar I'm not quite understanding your question? Am I right in thinking that if the time is after (say) midday then it should be DATE + 23:00:00, but if it's before it should be the DATE + actual time?

@Sasi Kumar With the given date in A1, then try this =IF(A1-DATE(YEAR(A1),MONTH(A1),0)>14,DATE(YEAR(A1),MONTH(A1),0)+15,DATE(YEAR(A1),MONTH(A1)-1,15)) Edit: Can't seem to get this in one line?

Here's a video on how to do it

Hi @Busymanjohn A free version is still available here

When you've worked it out @NARAYANK991 let me know the answer as well :DD:DD:eek:

If you also want the alphabets in another cell - assuming just one each end =LEFT(D2,1)&RIGHT(D2,1)

Happy birthday @Hui , you're catching me up!

@Sasi Kumar If you need to know more about Tables take a look at this video

Don't use DATEDIF, but use the formula @Khalid NGO posted in nr.10 above