| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date, Weekdays
Hi! Could you please help me with date formula. I need to enter 2 days before but it must be a weekday. e.g 12 Sep 2005 must show 9 Sep 2005 and also 13 Sep 2005 must show 9 Sep 2005. What I have is NOW()-2 , but it shows 10 Sep 2005 which is wrong. -- Heckstein ------------------------------------------------------------------------ Heckstein's Profile: http://www.excelforum.com/member.php...o&userid=27153 View this thread: http://www.excelforum.com/showthread...hreadid=466653 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| search for latest date | Excel Worksheet Functions | |||
| Subtracting weekdays from a date: | Excel Worksheet Functions | |||
| count weekdays in a date range | Excel Worksheet Functions | |||
| Date exclude weekdays | New Users to Excel | |||
Threaded Mode
