Calling all Excel Guru...Again!

-

alright, time made file guys can see want achieve:

https://onedrive.live.com/redir?resi...154c70!12160

there 2 tabs in workbook. on "good" tab, dates converted first of month. instance, 3/13/14 on "date" column 3/01/14 on "mm/yy" column.

on "bad" tab however, "mm/yy" looks same in "good" tab still retains same date value in "date" column. instance, 3/13/14 on "date" still 3/13/14 on "mm/yy".

mm/yy on "good" tab result want. did once...remember involved pasting clipboard forgot how again. can enlighten me? thank you.
 

your file says deleted. regardless, if you're trying first of month given date, try:

a1 3/13/2015. in b1, put:

= date(year(a1), month(a1), 1)

if end of month, there's built-in formula = eomonth(a1, 0)
 


Forums Macs Mac Apps and Mac App Store


  • iPhone
  • Mac OS & System Software
  • iPad
  • Apple Watch
  • Notebooks
  • iTunes
  • Apple ID
  • iCloud
  • Desktop Computers
  • Apple Music
  • Professional Applications
  • iPod
  • iWork
  • Apple TV
  • iLife
  • Wireless

Comments

Post a Comment

Popular posts from this blog

Pasco WA. Cops Killing A Homeless Man while running away

-
Image
can't put video guess threw few rocks ran away shot him while running away , turning hands out beg mercy. http://www.foxnews.com/us/2015/02/1...s-with-rocks-before-police-used-deadly-force/ video footage of police gunning down 35-year-old homeless man on february 10, 2015 shows man hands in air, attempting surrender, moments before police fired multiple shots, ending life. fourth time in 6 months, police in pasco, washington used lethal force against citizen. latest shooting victim, antonio zambrano-montes leaves behind 2 teenage daughters, father suffering depression after being separated them unknown reasons. video, credited dario zuniga, uploaded youtube ceeloc187 on wednesday, february 11. shows zambrano-montes toss stone @ police officers, turn , begin run away. series of gun shots can heard man tries flee. police pursue him across street in front of crowd of witnesses, gunning him down on sidewalk, raises arms above head in obvious
Read more

Gold Apple Watch Buyers to Get Special Purchasing Experience With 30 Minute Appointments

-
Image
of april 10, apple begin scheduling appointments in retail stores customers interested in trying on apple watch before deciding pre-order or make purchase. we've known try-on appointments scheduled in 15-minute intervals allow apple employees many customers possible, seems customers interested in purchasing gold apple watch edition time device. according international business times , 2 apple stores in manhattan have confirmed customers looking spend upwards of $10,000 on apple watch edition 30 minute appointments apple employees instead of 15 minute appointments. ​ given high price of apple watch edition, it's no surprise employees plan dedicate more time plan spend lot of money, it's bigger purchasing decision. in fact, purchasing experience gold apple watch may quite bit different experience purchasing standard apple watch or apple watch sport, apple said have dedicated group of employees have undergone special training serving cus
Read more

Transferring URLS

-
i wondering peoples' method transferring link between iphone , computer , vice versa. say, example, you're using website on mac , you'd transfer iphone view. how it? copy paste url facebook thought surely else has devised quicker means...   i use app called pocket.. it's available ios , os x. i'm not sure if there native client pc can add url pocket within modern web browser. and, pocket lets keep url's in list until remove them. more information can found @ https://getpocket.com   Forums iPhone, iPad, and iPod Touch iOS iOS 8 iPhone Mac OS & System Software iPad Apple Watch Notebooks iTunes Apple ID iCloud Desktop Computers Apple Music Professional Applications iPod iWork Apple TV
Read more