Hi All,
From the Data sheet, I need to capture Year, month and Qtr based on available date in two columns C and D. If Date is available for column D (Releasedate), extract year from it and if missing, extract year from col B. How to set a formula.
Also, how can I refresh a pivot for addition/deletion of new records in data sheet
Please check attached excel for input data
in cell E2 and drag down
Please Login or Register to view this content.
As far as refreshing data, the data tab at the top has a refresh all button.
Last edited by AliGW; 07-21-2021 at 02:55 AM. Reason: PLEASE don't quote unnecessarily!
In E2:
=IF(D2="",YEAR(C2),YEAR(D2))
In F2:
=IF(D2="",TEXT(C2,"mmm"),TEXT(D2,"mmm"))
In G2:
=LOOKUP(IF(D2="",MONTH(C2),MONTH(D2)),{1,4,7,10},{"Q1","Q2","Q3","Q4"})
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks