formatting dates
If you want to list consecutive workdays, beginning with the value in A1, try
this:
A1: (StartDate)
A2: =IF(A1="","",A1+MATCH(TRUE,(WEEKDAY(A1+{1,2,3},2)< 6),0))
Copy A2 down as far as you need
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"CC" wrote:
For the following formula,
=IF(A1="","",A1+1)
note: where A1 is a start date
How do I format it for weekdays only?
I'm trying to create a schedule template that will work backwards.
Thanks in advance for your help.
|