So I am using a formula to convert a date in one column to a quarter and year in another (sample spreadsheet attached). I needed to keep the cells with the formula blank if there was no date entered so the formula I am using is:
=IF(F4="","","Q"&INT((MONTH(F4)/4)+1)&"-"&RIGHT(YEAR(F4),2))
I thought it was working correct until I noticed some of them showing the wrong quarter. Example would be F3 to I3 and G3 to J3. If anyone could please help I would appreciate it.
Many thanks,
Josh
Hi Josh,
So F3, what quarter is that?
Do you quarters run Jan to Dec?
HTH
Regards, Jeff
Q1/Jan-Mar
Q2/Apr-Jun
Q3/Jul-Sept
Q4/Oct-Dec
How does this work...
=IF(N(F3),"Q"&LOOKUP(MONTH(F3),{1,4,7,10},{1,2,3,4})&"-"&YEAR(F3),"")
Hi jayc2111
Another way maybe of some use.
Formula:
Please Login or Register to view this content.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks