Every time I copy a date from one file to another, it adds 1 day & 4 years to the date.
Does anyone know a fix for this?
Thanks!
Katie
Copying dates from one workbook to another
-
-
Sounds like you have one book set to 1900 and one set to 1904 date systems.
Let BG explain it to you, he's richer than me :nana:
-
Thank you so much!
Lots of Aussies on this board!
Katie :wink1:
-
I'm not an Aussie !!!!!!! :o2
A Pommie and proud of it :coolwink:
I'm just working in Sydney for a while. Handing back to Bangkok in 2 weeks for a few months and then back to blighty for a beautiful English summer :no:
-
Had to look that one up!
Thanks again!
-
-
Quote
Lots of Aussies on this board!..and some lost swedish XL-users as well from other countries around our beatiful world :coolwink:
-
Quote
Originally posted by XL-Dennis
..and some lost swedish XL-users as well from other countries around our beatiful world :coolwink:
I have noticed most of the users I've seen are on your side of the pond. I'm sure I'm not the first Texan...:coolwink:
-
Didn't think the Net had reached most of Texas yet !!? :coolwink:
-
Quote
Originally posted by noeyedeer
Didn't think the Net had reached most of Texas yet !!? :coolwink:That's just not right...we're not all hicks!
:duh: -
Quote
I'm sure I'm not the first Texan...No and hopefully not the last either :flower:
-
-
Actually Katie, I was in Texas last autumn. I have a buddy living in Dallas so we went to see the Southfork ranch !!!:coolrsvd:
And I loved Austin and Houston was fun. So I know you're not ALL hicks :coolwink:
-
Austin is pretty cool. Houston is ugly. But Dallas is the spot...that's where I am.
Since you're online, you want to take a stab at a formula problem?
-
Sure I'll have a look at a formula.
Dallas was pretty fun, met some nice people there down in Greenville (I think that's what it was called, the area with loads of bars and clubs ?)
-
Yeah, it's Greenville Ave, tons of bars...pretty fun.
I'm having a problem joining 2 formulas together. Probably something goofy with my ()'s.
:cheers:
-
Got this far, need to nip out for lunch !!
=IF(DATE(YEAR($A4),MONTH($A4),1)<=DATE(YEAR(D$3),MONTH(D$3),1) & DATE(YEAR($B4),MONTH($B4),1)>DATE(YEAR($D3),MONTH($D3),1),$C4,"-")
:puzzled:
-
-
Brilliant! I just changed the & to IF and made a small adjustment and this serves my purpose VERY NICELY!
Thank you SO much for your help!
:kiss:
Katie -
Glad to be of assistance :bouncy:
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!