| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with dates
Does anyone out there have a formula that looks at cell (H5) in which it
contains a date (mm/dd/yy) and returns a 1 if the date is older than 30days from today or 0 is false? Or better yet conditionally format the cell (H5) in Red if older than 30 days from today. TIA Peter |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with dates
Try this formula...
=IF(TODAY()-H530,1,0) Rick "Looping through" wrote in message ... Does anyone out there have a formula that looks at cell (H5) in which it contains a date (mm/dd/yy) and returns a 1 if the date is older than 30days from today or 0 is false? Or better yet conditionally format the cell (H5) in Red if older than 30 days from today. TIA Peter |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with dates
To apply the conditional formatting, select H5 then click on Format |
Conditional Formatting, then choose Formula Is rather than Cell Value Is in the first box and put this formula in the next box: =TODAY()-H530 Then click the Format button, select the Patterns tab (for background colour) and choose red. Click OK twice to exit the dialogue box. Hope this helps. Pete "Looping through" wrote in message ... Does anyone out there have a formula that looks at cell (H5) in which it contains a date (mm/dd/yy) and returns a 1 if the date is older than 30days from today or 0 is false? Or better yet conditionally format the cell (H5) in Red if older than 30 days from today. TIA Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
Linear Mode
