I have 2 columns with 2 different dates.
Column 1 Column 2
4.28.2022 random dates
I need column 2 to only filter on dates that's beginning 4.1.2022 and up and this is for a monthly report. Can anyone help me out here?
Use a Filter tool, and select the radio button for Custom filter:
[Column 2] >= [Column 1]
sorry i may have written my explanation wrong. I need column 2 to show the 1st of the month of column 1. So whatever date we have in column 1 then column 2 should just show the 1st of that month.
how would i make it more than 1st of the month?
Hey @ntudev, What do you mean by more then the 1st of the month? You could use the datetimeadd function to add a given number of days or months on if you want.
i want to say >= firs of the month.
Can you provide sample input and output, in Excel? I don't think I understand your requirements.
Chris