Macro to Add Weekend Dates

M

Monk

Hello

I have excel data in two columns. The first column comprises dates covering
a period but it excludes weekends. The second column comprises dollar values
relevant to the applicable weekday.

What I would like to do is add dates for the weekends in the first column
and then copy the values for the preceding Friday into the second column for
those added weekend dates.

Any assistance you could provide would be appreciated.

Thanks

Monk
 
B

Bob Bridges

Do you need to insert new rows for the weekend dates, Monk? or just tack them
on to the end? And how far have you gotten so far? I mean, you ask for
assisstance but I can't tell what your program looks like and which part you
need help with.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
counting weekends 2
Weekend dates conditional format 3
Macro to add column and insert date then in blank cells copy fromprevious cell 1
Assigning values to dates 7
Count difference in days input box 4
match one column with dates to several colums with dates, copy pas 4
How to shift a weekend date to the last or next workday 2

Top