| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Question Regarding Dates
=IF(A1TODAY(),100,0) Will only work if A1 is formatted as a date, I believe.
Dave -- Brevity is the soul of wit. "PHEB" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Question Regarding Dates
Try this:
=if(a1<today(), $100, 0) Hope this helps. Pete PHEB wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Question Regarding Dates
Dave,
that would put A1 in the future to return 100. Pete Dave F wrote: =IF(A1TODAY(),100,0) Will only work if A1 is formatted as a date, I believe. Dave -- Brevity is the soul of wit. "PHEB" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Question Regarding Dates
You're close.
The parentheses follow the function, not precede it. Also, take out the '$', leaving just the number, =if(a1<today(),100,0) If you want $ to appear, format the cell as currency. -- Regards, Fred "PHEB" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
