Hello
In google sheet
https://docs.google.com/spreadsheets...it?usp=sharing
In Google Sheet, Column G, it is Vlookup formula and I need to output in date format
instead of text. Because of this the YEARFRCC is in Column K is not working
How to resolve this please
In your google sheet column "G" & "K" is totally blank,
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Apologies, Kindly see sheet Investments
It has now full access to anyone with link
Issue is your formula in NAV sheet column "F"
Formula:
Please Login or Register to view this content.
This is not date format in excel language.
NAV sheet is fetched from web and is real time data
Last edited by grcshekar; 03-11-2023 at 06:45 AM.
In Excel I created a table like this and it worked but in google sheet I do not know how do the same
= Table.TransformColumnTypes(#"Promoted Headers",{{"Scheme Code", type text}, {"ISIN Div Payout/ ISIN Growth", type text}, {"ISIN Div Reinvestment", type text}, {"Scheme Name", type text}, {"Net Asset Value", type number}, {"Date", type date}})
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks