Dates and Columns

Not applicable

Hello all, I'm creating an excel sheet to track poundage of food donated from my nonprofit.. What I need is how to put the dates in columns. But i need two of each date.. so like column A1 01/01/2019, column b1 01/01/2019, C1 01/02/2019, D1 01/02/2019, E1 01/03/2019, F1 01/03/2019 and so on.. Any help would be greatly appreciated! Thanks in advance!



2 Replies


Hi Travis,


You need to insert a starting date in cell A1, you can use this formula to do so:



Then, use this formula below in cell B1 and drag it to right to get the result as the screenshot below.


Duplicate dates twice.png




Hope that helps


@Haytham Amairah Thank you!! Very helpful I appreciate it!!

Related Conversations
Date filtering of Bing Searches
PhilipE3 in Discussions on
2 Replies
Setting Date in Stored Procedure
Tim Hunter in SQL Server on
1 Replies
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
Add Column Using Count
Tim Hunter in SQL Server on
0 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies