auto date calculation

honda_dude32

New Member
Joined
Dec 29, 2005
Messages
2
I am looking to have a date calculated based on today's date to 30 days in future. If this date is Tuesday for example then I want to goto last Thursday. For example if today 12/30/05, so 30 days in future is around 1/30/06 which falls on Monday. The formula should calculate the date to 1/26/06. Same for 90 days. Greatly appriciate your help!
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Watch MrExcel Video

Forum statistics

Threads
1,118,433
Messages
5,572,080
Members
412,439
Latest member
BKPE
Top