Excel and Date Functions

[Dryver14]

Am I the only person that thinks Excel is sadly lacking in date functions?

Is it too hard for them to do?

So many questions generated here are the same and I think excel must have spotted this calculating time and changing time from GMT to UTC etc are very common actions for excel users.

 

[Michael M]

What !!!!....you actually want Bill (Gates) to do something extra for the masses, Shame on you, after all he's done for you.

But honestly, I think date stuff is too hard, that's why blokes like Chip Pearson have to have websites to do it for them !!
Oh, the heaven of it........A date function Addin !!!

 

[Oaktree]

I'd be content if they just added DATEDIF to Excel help's documentation and stopped having it be a stealth function.

 

[diddi]

so how about a bit of a group effort to

a) construct a list of useful date and time functions and then
b) design and implement a free addin for fellow mrexcelers

i have coded for astronomical date and time functions if the masses think that they would be useful (eg julian date<>calendar date)

 

[Domski]

I'd be content if they just added DATEDIF to Excel help's documentation and stopped having it be a stealth function.

And fix the bugs in it so you're sure it giving the correct results.

Dom

 

[jasonb75]

changing time from GMT to UTC

I'm pretty sure =A1/1^9.9E+307 works for that, as does changing / to * to convert the other way.

 

[xenou]

Changing time from GMT to UTC?

 

[xenou]

Quote:
Originally Posted by Dryver14 View Post
changing time from GMT to UTC
I'm pretty sure =A1/1^9.9E+307 works for that, as does changing / to * to convert the other way.

Brilliant. Works for me:
<img alt="screenshot" src="http://northernocean.net/etc/mrexcel/20111202_utc.png" />

 

[jasonb75]

Brilliant. Works for me:

There was me thinking it would go un-noticed

 

[xenou]

Methinks you have a future as a MS software engineer if you keep this up