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
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
Use data validation for the cells in which you entering dates
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
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.
a2=A1+IF(WEEKDAY(A1)=7,2,1)Try this in A2 and copy towards downPlease Login or Register to view this content.
Great!
Thanks!
p.s
I tried but: "You must spread some Reputation around before giving it to nflsales again."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks