Home

Dates and Columns

Deleted
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!

 

Travis

2 Replies
Highlighted

 

Hi Travis,

 

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

=DATE(2019,1,1)

 

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

=IF(MOD(COLUMN(),2)=1,A1+1,A1)

Duplicate dates twice.png

 

@Deleted

 

Hope that helps

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies