How to put date automatically for whole month

kalpeshkansara

New Member
Joined
Dec 15, 2016
Messages
43
I have worksheet of employees for salary sheet calculations.
67065451_10157662811257280_2631599167465586688_n.jpg


This worksheet have date format need to get every month dates automatically which currently put manually.
also days put from past link of whole date each cell's same value to left side of every dates and changed its format to show only days so its showing days only. but wanted to do color red in every Sundays which is not able to apply by conditional formatting to do red color on days for "Sun".

What to do I don't understand for the dates.
Help me if you have any formulas for automatic dates and for days need red color in every Sun.

Waiting for reply
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Its working but date we have to take from each cells of left a2, a3, a4... but not like this.

I have to enter only one time that new month starts like Jul/2019 at B2 and by this whole date will come automatically in respective rows.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

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
Back
Top