Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with a date function formula
I have an excel sheet header which includes a date, the date is to represent yesterday's date ( =Today()-1 ), which then would come into the spread sheet as August 8th, 2005, assuming today was August 9th. The problem is on days like Monday when the previous day was sunday, how can I make the formula output the Friday before the Monday instead of Sunday ...example on Monday, August 11th, the formula would read August 10th, I need it to read August 8th...? Please help, thanks -- KAA ------------------------------------------------------------------------ KAA's Profile: http://www.excelforum.com/member.php...o&userid=26755 View this thread: http://www.excelforum.com/showthread...hreadid=400071 |
#2
|
|||
|
|||
Try...
=WORKDAY(TODAY(),-1) ....which requires that the Analysis ToolPak be enabled... Tools Add-Ins and check Analysis ToolPak Hope this helps! In article , KAA wrote: I have an excel sheet header which includes a date, the date is to represent yesterday's date ( =Today()-1 ), which then would come into the spread sheet as August 8th, 2005, assuming today was August 9th. The problem is on days like Monday when the previous day was sunday, how can I make the formula output the Friday before the Monday instead of Sunday ...example on Monday, August 11th, the formula would read August 10th, I need it to read August 8th...? Please help, thanks |
#3
|
|||
|
|||
Try this:
=IF(WEEKDAY(NOW()-1)=1,(NOW()-3),NOW()-1) "KAA" wrote: I have an excel sheet header which includes a date, the date is to represent yesterday's date ( =Today()-1 ), which then would come into the spread sheet as August 8th, 2005, assuming today was August 9th. The problem is on days like Monday when the previous day was sunday, how can I make the formula output the Friday before the Monday instead of Sunday ...example on Monday, August 11th, the formula would read August 10th, I need it to read August 8th...? Please help, thanks -- KAA ------------------------------------------------------------------------ KAA's Profile: http://www.excelforum.com/member.php...o&userid=26755 View this thread: http://www.excelforum.com/showthread...hreadid=400071 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to use IF formula with a Date cell | Excel Worksheet Functions | |||
Using date function in an if statement | Excel Worksheet Functions | |||
Date Formula | Excel Discussion (Misc queries) | |||
Date formula | Excel Discussion (Misc queries) | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |