My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Add Date to columns|VBA & Macros|Excel Forum|My Online Training Hub

You are here: Home / Add Date to columns|VBA & Macros|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Add Date to columns
Avatar
David Ng

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
June 27, 2024
sp_UserOfflineSmall Offline
1
June 27, 2024 - 2:14 pm
sp_Permalink sp_Print

How to use macro add missing dates for full month May 2024 for an  attendence    report 

Avatar
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Moderators
Level 1
Forum Posts: 1053
Member Since:
January 31, 2022
sp_UserOnlineSmall Online
2
June 27, 2024 - 3:28 pm
sp_Permalink sp_Print

Please provide some more details. How does the report look like? Why do you want to use VBA?

Avatar
David Ng

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
June 27, 2024
sp_UserOfflineSmall Offline
3
June 27, 2024 - 7:20 pm
sp_Permalink sp_Print

See attachment 

F Column [ Attend date] 

say DG800032 not working on 05/07/2024 05/09//2024 05/10/2024 05/11/2024 05/12/2024 but working 05/08/2024 Wed  05/13/2024 Mon  etc etc 

ie show each staff working on or not working in the month of May 2024 base on attach file data 

 

ID Name Department Attend Date
DG800032 鍾, 耀鞍 DG-OFFIC, TAIPO_R 05/08/2024 Wed
DG800032 鍾, 耀鞍 DG-OFFIC, TAIPO_R 05/13/2024 Mon
DG800032 鍾, 耀鞍 DG-OFFIC, TAIPO_R 05/22/2024 Wed
DG800032 鍾, 耀鞍 DG-OFFIC, TAIPO_R 05/29/2024 Wed
DG800032 鍾, 耀鞍 DG-OFFIC, TAIPO_R 05/31/2024 Fri
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/01/2024 Wed
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/03/2024 Fri
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/04/2024 Sat
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/05/2024 Sun
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/06/2024 Mon
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/07/2024 Tue
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/08/2024 Wed
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/09/2024 Thu
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/10/2024 Fri
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/11/2024 Sat
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/12/2024 Sun
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/13/2024 Mon
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/16/2024 Thu
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/18/2024 Sat
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/19/2024 Sun
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/20/2024 Mon
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/22/2024 Wed
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/23/2024 Thu
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/24/2024 Fri
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/25/2024 Sat
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/26/2024 Sun
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/27/2024 Mon
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/30/2024 Thu
DGOF0016 馮, 確強 0PT, CHUNGON, DG-OFFIC, SHAKOK, SHAT-C, TAIPO_R, TMFC 05/31/2024 Fri
DGOF0023 Lo, Ling DG-OFFIC, TSOFFICE 05/02/2024 Thu
DGOF0023 Lo, Ling DG-OFFIC, TSOFFICE 05/03/2024 Fri
DGOF0023 Lo, Ling DG-OFFIC, TSOFFICE 05/04/2024 Sat
DGOF0023 Lo, Ling DG-OFFIC, TSOFFICE 05/10/2024 Fri

 

Date

05/01/2024  

05/02/2024
05/03/2024
05/04/2024

so on   till

05/31/2024       

to show each staff working or no on the date 

Avatar
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Moderators
Level 1
Forum Posts: 1053
Member Since:
January 31, 2022
sp_UserOnlineSmall Online
4
June 28, 2024 - 4:21 pm
sp_Permalink sp_Print sp_EditHistory

Why not with formulas using COUNTIFS, or (power) pivot tables? I've included some examples in your workbook.

Avatar
David Ng

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
June 27, 2024
sp_UserOfflineSmall Offline
5
July 1, 2024 - 12:58 am
sp_Permalink sp_Print

Thanks  Riny the solutions. 

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 930
Purfleet: 415
Hans Hallebeek: 356
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Stephen Brown
D Roberts
MC Hoed
joseph lee
Simon Musker
Dennis M
Yiannis A
John Kang'ara
Forum Stats:
Groups: 3
Forums: 25
Topics: 7096
Posts: 31114

 

Member Stats:
Guest Posters: 49
Members: 34536
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen