Date and CONCATENATE
I'm having a problem getting the date to show up when I add the date as a referenced cell to a formula using CONCATENATE. The date shows up as a serial value instead of a date format. The formula that I'm trying to get to work is in cell J7 on the attached file.
Last edited by Speclt; 01-08-2010 at 03:09 PM.
Try =IF(I7=""," ",IF(H7=0,"UPDATE PRICE",IF(H7>0,CONCATENATE("UPDATED "," ",TEXT(Z228,"d-mmm-yy")," "))))
Change your current formula in J7
FROM:
TO:
Please Login or Register to view this content.
Please Login or Register to view this content.
Re: Date and CONCATENATE
Thanks darkyam and ncmay for your help. This works great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks