Future Day's

[TJVFree]

Hi,
I’m trying to find a formula that will pull the date for the future days Tuesday, Wednesday, Thursday, and Friday.
The formula’s I was using pulled the data from the previous week until It’s that day.

=Format(Date()-(Weekday(Date(),2))+1,"mm/dd/yyyy")

=Format(Date()-(Weekday(Date(),2))+2,"mm/dd/yyyy")

=Format(Date()-(Weekday(Date(),2))+3,"mm/dd/yyyy")

=Format(Date()-(Weekday(Date(),2))+4,"mm/dd/yyyy")

=Format(Date()-(Weekday(Date(),2))+5,"mm/dd/yyyy")


TCB

 

[dhookom]

Please provide some samples of what exact values you are hoping to return from the expressions based on maybe today being Mar 16th or any other date.

Duane
Hook'D on Access
MS Access MVP