Omit Sundays in date filling

**drgkt** · 10-30-2015, 03:21 AM

xp sp2 Excel xp (2002)

When filling dates, Excel has the option to fill just weekdays omitting Saturdays and Sundays.

What if I want to omit JUST the Sundays?

Thanks

**samba_ravi** · 10-30-2015, 03:23 AM

Use data validation for the cells in which you entering dates

**drgkt** · 10-30-2015, 04:00 AM

Perhaps you might explain further...

I type today's date (not a Sunday) on A1 and I want with one command to fill A2..A300 with subsequent dates, except Sundays.

**samba_ravi** · 10-30-2015, 04:21 AM

a2=A1+IF(WEEKDAY(A1)=7,2,1)

Please Login or Register  to view this content.

Try this in A2 and copy towards down

**drgkt** · 10-30-2015, 04:48 AM

Great!
Thanks!

p.s
I tried but: "You must spread some Reputation around before giving it to nflsales again."

Omit Sundays in date filling

LinkBack

Thread Tools

Rate This Thread

Display

Omit Sundays in date filling

Re: Omit Sundays in date filling

Re: Omit Sundays in date filling

Re: Omit Sundays in date filling

Re: Omit Sundays in date filling

Thread Information

Users Browsing this Thread

Similar Threads

display no of sundays and its date

[SOLVED] VBA Save a file with filename and last Sundays date.

Cell to calculate +3 working days from start date (Excluding Saturdays and Sundays)

[SOLVED] Date Formula - 1st,2nd & 3rd Sundays of each month

Date Validation - Must equal Sundays date

Return Sundays date of current week

Formula to get 1st,2nd,3rd,4th,5th Sundays from month end date.

Bookmarks

Bookmarks

Posting Permissions