| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Question Regarding Dates
If anyone can help with this scenario, it would be much appreciated. I want to compare a formula driven date with today's date in a spreadsheet. For example, if the date in one cell has already passed, then I want to have a value in another cell. If the date is in the future, then the value in the aforementioned cell would be null. Originally, I put =if(a1<()today, $100, 0), but it is obviously not correct. Can anyone drop a clue or two? Thanx. PHEB -- PHEB ------------------------------------------------------------------------ PHEB's Profile: http://www.officehelp.in/member.php?userid=4551 View this thread: http://www.officehelp.in/showthread.php?t=1217328 Posted from - http://www.officehelp.in |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple graph formatting question for dates. | Excel Discussion (Misc queries) | |||
| Conditional Formatting (Dates) Repost with additional data | Excel Discussion (Misc queries) | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Finding dates within a date range | Excel Worksheet Functions | |||
Threaded Mode
