| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
=IF(DAY(K3)DATE(YEAR(K3),MONTH(K3)+1,0)/2,A25-1,0)
-- HTH Bob Phillips "coal_miner" wrote in message ... I need an if formula that takes a date in cell K3 and determines if the month in that cell is halfway over. If it is not halfway over, then it subtracts the number 1 from cell A25. If the month is halfway over, then do nothing. Is this possible, and if so, please let me know. Much obliged. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add one month to the previuos month | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
| UserForm to select current month or earlier | Excel Discussion (Misc queries) | |||
| How to extract month number from month name | Excel Discussion (Misc queries) | |||
Hybrid Mode
