Hello All,
Happy Monday. I'm hoping someone can help me with this issue here. I've attached two images so you understand what I mean. Basically, our first week of the year in 2019 started in in 2018. That's how I group the week (7 days starting 12/31/2018). Then, when I group them as quarter, that was the problem. See, the first day of the week became 4th quarter. Is there anyway to fix this. I don't think the weeknum function works. Someone told me to use this formula to force the 2018 as 2019.
Formula:
=IF(A1>=DATEVALUE("12/31/2018"),2019,IF(A1>=DATEVALUE("12/31/2019"),2020))
Well, I got the year, but I also need the month so I can group it in quarter. Don't you think?
Thank you!
Happy Monday. I'm hoping someone can help me with this issue here. I've attached two images so you understand what I mean. Basically, our first week of the year in 2019 started in in 2018. That's how I group the week (7 days starting 12/31/2018). Then, when I group them as quarter, that was the problem. See, the first day of the week became 4th quarter. Is there anyway to fix this. I don't think the weeknum function works. Someone told me to use this formula to force the 2018 as 2019.
Formula:
=IF(A1>=DATEVALUE("12/31/2018"),2019,IF(A1>=DATEVALUE("12/31/2019"),2020))
Well, I got the year, but I also need the month so I can group it in quarter. Don't you think?
Thank you!