Auto populate days and dates including Saturday in Excel and convert to ms word files for each day and date

DIPASGL

New Member
Joined
Oct 26, 2022
Messages
4
Office Version
  1. 2003 or older
Platform
  1. Windows
Hello Everyone,

Hope someone can help me in this. I have started to create word file with the heading of day and date. Like today is 22/11/22 Tuesday so I created word for this and save. Now I have to do this for tomorrow or so on for the mid of next year INCLUDING SATURDAY as we have banking Mon to Saturday .
I was thinking is there any way I add today date and day in word and it create word sheets for the rest of year including Saturday. So far I tried on excel sheet this formula =IF(WEEKDAY(A1+1,2)>5,A1+3,A1+1) but thisone does not adding Saturday so how Can I add Saturday here and then guess copy from excel to word? Thank you
 

Attachments

  • ms word.PNG
    ms word.PNG
    41.1 KB · Views: 5
  • Excel.PNG
    Excel.PNG
    34.1 KB · Views: 5

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Forum statistics

Threads
1,186,440
Messages
5,957,843
Members
438,325
Latest member
fanofstuff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top