| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula would transpose stale dated cells?
I am trying to have stale dated cells copied into blank cells but cannot seem
to find a formula that might do that. Any character in the new cell would be fine as long as it highlights the old dates. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What formula would transpose stale dated cells?
Hi,
Not quite sure what you're after, but I'll have a go as much as I understand the question. If your stale date (does that mean a date older than today?) is in A2, then in B2 put =IF(A2<TODAY(),"Stale","") If you really want the old date in the new cell, then: =IF(A2<TODAY(),A2,"") For the 2nd option, make sure B2 is has a date format. Regards - Dave. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What formula would transpose stale dated cells?
Hi Debbie,
You could use conditional formatting with formula is =A1<TODAY(). That way your dates will be automatically highlighted as soon as they are past. HTH Martin "Debbie" wrote: I am trying to have stale dated cells copied into blank cells but cannot seem to find a formula that might do that. Any character in the new cell would be fine as long as it highlights the old dates. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula would transpose stale dated cells? | Excel Worksheet Functions | |||
| Charting Dated Data | Charts and Charting in Excel | |||
| blank vs. 0 when plotting a dated timescale graph | Excel Worksheet Functions | |||
| In Excel can you have a cell generate the last dated modified?? | Excel Discussion (Misc queries) | |||
| print spreadsheet with each coming day dated on it for 2006. | Excel Discussion (Misc queries) | |||
Linear Mode
