I have the data which has multiple dates.
I want to categorized it based on below.
Last 3 hours
Today
Yesterday
This Week
Last Week
This Month
Last Month
If the date is 15 may
I use =If(a2=today(),"Today",)
I have 4 columns in my sheet as
Date Day Week Month
So if the date is of today it should be displayed as This Month.
If date week no is same as of today it should be This Week
I want to categorized it based on below.
Last 3 hours
Today
Yesterday
This Week
Last Week
This Month
Last Month
If the date is 15 may
I use =If(a2=today(),"Today",)
I have 4 columns in my sheet as
Date Day Week Month
So if the date is of today it should be displayed as This Month.
If date week no is same as of today it should be This Week
Last edited: