Move Enite Columns based on Date

[melvinjoseph]

Hello,

I have an attendance tracker (downloaded from an online portal) where the dates (columns) are not sorted in ascending order.
Our pay cycle is from the 25th of a month till the 24th of the next month. However the export data from our online tool does not export the date in ascending order.

<gs id="3f231af8-2cff-413c-8f14-d9aa058ff600" ginger_software_uiphraseguid="917bd9c7-b31d-409c-8a0d-bd5571dd6961" class="GINGER_SOFTWARE_mark">i.e</gs> Column <gs id="3065497b-9184-4a49-9128-c747bdb9667b" ginger_software_uiphraseguid="bb5d9219-4d9c-4259-9ccf-966aa0bf6c78" class="GINGER_SOFTWARE_mark">F st</gs>arts with 1st Jan and goes on to column AC with the date 24th Jan
Column AC now starts with 25th Dec and goes on to column AJ with the date 31st Dec.

I would like the date in column F to start with 25th of every month rather than the first.

I have tried recording a macro to copy and paste these columns ahead. However, since the dates are expected to change every month this is not a viable option for me.

Sample File
https://drive.google.com/file/d/0B3pkl-b9s8s7XzJaT0JPMkdQcjg/view?usp=sharing

Thank You for all the help and suggestions
Melvin

 

[dmt32]

Have you tried using a formula to manage your date headers?

Try this & see if helps you:

In Cell F1:
=DATE(YEAR(NOW()),MONTH(NOW()),25)

In Cell G1:
=F1+1
and drag through to Cell AJ

Dates should update each month.

Dave

 

[melvinjoseph]

Hi Dave,

That would not work for me, <gs id="bfc2e9e1-ab40-4499-912d-7c9f06013629" ginger_software_uiphraseguid="95ced1c0-2473-44f4-b92b-b5c64cc0b6a7" class="GINGER_SOFTWARE_mark">i</gs> would like to be able to have the columns in the correct date order so <gs id="433b549b-aee0-486f-9606-5a5c63dc1752" ginger_software_uiphraseguid="95ced1c0-2473-44f4-b92b-b5c64cc0b6a7" class="GINGER_SOFTWARE_mark">i</gs> could have a continuous data set month over month.

Thanks
Melvin