Forum Discussion
Excel dates
Hello I have a quick question. I have data that I need to organize and I want to do it by the dates my employees work. But when I download the data it’s not formatted the way I need. For example, the...
Cto06 You can set up a few simple formulas as shown.
E2 finds the minimum date, E3 finds the maximum date.
D9 creates a sequence of dates from the minimum to maximum. You need to format the cells as date.
E9 uses XLOOKUP to find the date in the input list and bring over the amount. If the date is not found in the input list, it leaves the amount blank.