Excel Print Dates

[varunwalla]

How can print dates in excel from monday to friday in seperate column. Let say in

A1 i need to display the current date and in

A2 i need to display the next date and in

A3 i need to display the next date of column A2

but dates of saturday & sunday should not be displayed in A1,A2,A3

 

[onlyadrafter]

Hello,

in A1 - =IF(WEEKDAY(TODAY(),2)>5,TODAY()+2,TODAY())

in A2 - =IF(WEEKDAY(A1,2)=5,A1+3,A1+1)

then copy A2 into A3

Think this should work.

 

[Fluff]

Another option
In A1

=TODAY()

In A2 copied down

=WORKDAY(A1,1)